azieg... I'm a 'parts guy' and I'm confused as to what Your real issue/problem really is/are.
This could be as simple as an aircraft specific parts database... which starts with the parts manual [IPB]... then expands to include common Parts allowed in the AMM and SRM [for maintenance/repair]... or this could be a generic 'monster'... all inclusive for everything in aerospace database.
NOTE.
The direction I sense is that Your work is similar in intent to the monster-gorilla in the business... IHS... Standards Expert and HAYSTACK... which is massively encompassing and has ability to generate many segregated lists... and to a lesser degree... I think allows for imputing the variables mentioned... and being re-directed to specific generic specs. I don't think IHS has [nor could have] 'corporate standard parts' [see below]... but those could be added piecemeal at discretion.
OR is Your intent a focused/corporate-wide database for specific design styles... like my company which has a massive 'approved parts base' that includes generic and corporate standard parts across the spectrum... but limited for our business purposes.
Is your concern limited, to parts thus...
Structural?
Mechanical?
EE/EL?
materials [metals, plastics, fibers, coatings, sealants, etc]
and/or is topic-specific technical data [analytical] also required?
Standard - generic
AN/NASM
AS
MS/NASM
MIL/NASM
NAS
Stock-number or vendor procurable
standards - Corporate specific
[various fastener manufacturers, cherry, monogram, LISI Hi-Shear, etc]
[various bearing manufacturers, MBC, FAFNIR, etc]
[Various EE/EL components, AMD, INTEL, TI, etc]
etc.
NOTE. About 15-years ago I started a spreadsheet for parts I worked with all the time... my own format, short-hand, abbreviations, etc. suits my purpose... but it is no longer 'a baby'... topic areas, [in tab-order], thus...
NOTE. This is a ROAD-MAP ONLY... I know where to find the stuff... [I ironed-out all my personal abbreviations]
FH = Flush Head
PH = Protruding Head
Bolts, Blind, PH & FH
Bolts, Threaded ~ FH
Bolts, Threaded ~ PH
Clamps, Grommets
Fillers-Retaining Rings-Shims-Spacers-Washers
Bushes-Plain Bearings-Sleeves
Hi-Lok Collars
Hi-Lok Pins ~ FH & PH
Inserts ~ Threaded
Lock-Bolts ~ Swaged Collar ~ FH &PH
Nuts
Nutplates
Panel & Cowl Fasteners
Pins, Spring-Pins
Rivets, Blind ~ FH & PH
Rivets, Blind ~ Non Structural
Rivets ~ Solid ~ FH & PH
Rods & Studs ~Threaded
Screws ~ Full Threaded ~ FH, PH, Set
Countersinks ~Rivet Head equivalent
Holes ~Bolts
Holes ~ Rivets
Drill Bit Data NAS907-932-937-965-J2122
Reamer-Bit Data [corporate]
Reamer-Bit Data ~NAS897-898-J2124
Spotfaces
[several torque tables for many type fasteners for various situations... and s’more stuff]
Specifications Related to Listed Parts (a wild/hairy bunch of generic/fastener-related info... packed into-one-space)
Regards, Wil Taylor
o Trust - But Verify!
o We believe to be true what we prefer to be true. [Unknown]
o For those who believe, no proof is required; for those who cannot believe, no proof is possible. [variation,Stuart Chase]
o Unfortunately, in science what You 'believe' is irrelevant. ["Orion", Homebuiltairplanes.com forum]