AD 90-06-13
Registered aircraft · 1,827
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:90-06-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:90-06-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:90-06-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:90-06-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.
N4047CInternational Air Services Inc Trustee · Carson City, NVN404BYMalagamar LLC · Fort Myers, FLN404DPValie Air LLC · Statesboro, GAN404GCushing Stone Company Inc · Amsterdam, NYN404RPBig Eagle Aviation LLC · Longview, TXN406CTCentral Virginia Aviation Inc · Petersburg, VAN406CUSs Leasing II LLC · Eau Claire, WIN406EJLynch Flying Service Inc · Billings, MTN406RD406 Aviation LLC · Lake City, FLN409RATurbo Air Charter LLC · Boise, IDN40EPIntrepid Air LLC · Las Vegas, NVN40MFCb20mf LLC · Stuart, FLN40RDynamic Avlease Inc · Bridgewater, VAN410DMJmp Aircraft Services LLC Trustee · Wasilla, AKN410JPEdwards Pacific Aviation Corp · Dover, DEN411MHObair 26 LLC · Memphis, TNN412BTPrestige Aviation LLC · Wixom, MIN413CREdwards Stone Inc · Roca, NEN413CTEagle LLC · Missoula, MTN413MHFastair Inc · Columbia Station, OHN413RCGreen Steam Aviation LLC · Springfield, ILN415AJG&G Transportation LLC · Kalispell, MTN416BABtt Air LLC · Wilmington, DEN416CCMadera Jet Center Inc · Madera, CAN418KWNorthshore Air LLC · Mandeville, LAN418RRBravo 18rr LLC · Wilmington, DEN419MNSouthern Justice Aviation LLC · Houston, TXN41GAClt Logging Inc · Grenada, CAN4200KVs Airco LLC · Humble, TXN420TAElectronic Caregiver Inc · Las Cruces, NMN421JBBravo 996 LLC · Boca Raton, FLN423HKGem Air LLC · Bakersfield, CAN42592Tpl Flight LLC · Fish Creek, WIN425GTOrion Aerial LLC · Reno, NVN425STSale Reported · Northowram HalifaxSale reportedN425TRDct Aviation LLC · Conway, ARN427MCN427mc LLC · Bay City, MIN427RRTvpx Ars Inc Trustee · North Salt Lake, UTN428MMRegistered aircraftN42EOak Street LLC · Louisville, KYN42PHOrion Aerial LLC · Reno, NVN42ZDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN430AMJems Air Inc · Glenwood, MDN430MCDenault John B III · Fullerton, CAN430SALks Aviation LLC · Birmingham, MIN430TATeam Aero LLC · Olathe, KSN431MSTexas Aircraft Parts Brokers LLC · Seguin, TXN432RJWings LLC · Homewood, ALN432TXStagg Air LLC · Midland, TXN438CRKilo Alpha 438 LLC · Edgewater, FL
Back to AD 90-06-13