AD 96-03-13
Registered aircraft · 1,042
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:96-03-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-03-13')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:96-03-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-03-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N433HCKrabby Apple Trading LLC · Wilton, CTN433JMN433jm LLC · Dallas, TXN436EAN436ea LLC · Sanford, FLN437WFHewitson Enterprises Inc · Avenal, CAN438CRKilo Alpha 438 LLC · Edgewater, FLN438FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN438SErie Aviation LLC · Salem, ORN43ADynamic Avlease Inc · Bridgewater, VAN440PCsw Investments LLC · Dover, DEN4415LIdaho State University · Pocatello, IDN442KAMoore Horizons LLC · Murrells Inlet, SCN442PLBank Of Utah Trustee · Salt Lake City, UTN444ADApex Aviation Holding LLC · Kalispell, MTN444KASky Hye Air LLC · Hye, TXN444LPTri Supply LLC · Beaumont, TXN444RKOrmond Beach Jet LLC · Ormond Beach, FLN4490MIndian Ink Leasing Inc · Amarillo, TXN449JSThomas Hanka Aviation LLC · Mission, TXN44KAHunter Aviation Of Tampa LLC · Saint Petersburg, FLN44MRSummit Helicopters Inc · Salem, VAN44UDynamic Avlease Inc · Bridgewater, VAN44USEagle Creek Aviation Services Inc · Indianapolis, INN450NANational Aerotech Aviation Delaware · Wilmington, DEN454DCEllis Dd King Air LLC · Midlothian, TXN454GQSwifton Aviation Inc · Swifton, ARN454TMKardecas Corp · Houston, TXN456ESTripp Aviation LLC · Pearland, TXN456PFCivic Aviation LLC · Miami, FLN459DFState Of California · Mcclellan, CAN459MARani9650 LLC · Lathrop, CAN461DFState Of California · Mcclellan, CAN463DFState Of California - Cal Fire · Mcclellan, CAN465BKDodson International Parts Inc · Rantoul, KSN466MW1977 Holdings LLC · Visalia, CAN468SPPacific Mission Aviation · Hagatna, GUN469SLAngely Air LLC · Lewes, DEN46BRCds Aviation Consulting LLC · Dover, DEN46CECentury Equipment Company Inc · Salt Lake City, UTN46JXKing Air 3au LLC · Wichita, KSN46LDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN477JMBehrens Aircraft Leasing LLC · Waukesha, WIN479AKSafeco Leasing LLC · Port Alsworth, AKN479BRGunner Aviation LLC · Fayetteville, ARN479VATactical Aviation Inc · Wilmington, DEN480BRFive Diamond Aviation Holdings LLC · Draper, UTN481HCIntermountain Medical Transport LLC · Salt Lake City, UTN485KBravo Hotel LLC · Lewes, DEN486ATMeo Holdings LLC · Newark, DEN487FPBallard Aviation Inc · Newton, KSN487JHCtgx Holdings LLC · Alpine, WY
Back to AD 96-03-13