AD 90-04-06 R1
Registered aircraft · 68,369
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-04-06-R1')
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-04-06-R1')
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-04-06-R1') 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-04-06-R1') 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.
N1612AGlover Thomas B · Marana, AZN1612EPavlovitch Marion T · Northridge, CAFirst renewal noticeN16130Ackerman Garry · Plano, TXN16134Adibi Saeed · Huntsville, ALN16137Hines Roger E · Greenville, OHN1613GInglis Jeffrey R · Hampton, NHN1613HHampton William R · Marietta, GAFirst renewal noticeN1613RGregg Jeffrey B · Sun Valley, CAN1613VMcewen Michael A M D · Gadsden, ALN1613WArnold Stephen Paul · Falls Church, VAN16142Ballen Bradely · Sky Valley, CAN1614GGriffin Donald A · Alma, ILN1614JCoraggio Joseph · Chandler, AZN1615EFisher Ralph B · Lutz, FLN1615VFrance Jeffrey A · Reedville, VAN1616GGorton Trice J · Anchorage, AKN1616HMayworm Jeffrey A · Ocala, FLN1616POwen David C · Fort Myers, FLN1616RBerck Michael P · Clackamas, ORN1617GDuch Jose M · Miami, FLN1617HFlying Cloud Cherokees Inc · Chanhassen, MNN1617VCook Timothy D · Ashville, NYN16182Miller Richard F · Lusby, MDN16185Schwartz David W · Windsor, NYN16186Omega 1 Corp · Middletown, DEN1618CGerow Dennis L · Austin, TXN1618GBlue Moon Flying Club LLC · Westminster, MDN1618HMemrick Paul · Cedar Park, TXN16190Mgs Ventures Ltd · Wilmington, DEN16199Allbritton John Mark Trustee · Oakland, TNN1619RNorman Richard L · Dallas, GAN161AMDe Boissard Karen · New York, NYN161AWAir Ward Inc · Columbia, CAN161BGWilson James R · Midlothian, VAN161BTCoffin Craig T · Glendale, CAN161DFulper Lester D · Clearwater, FLN161DERegistered aircraftN161DSHeffron Neuhold Nicholas A · Honolulu, HIN161GBEagle Aviation LLC · Anchorage, AKN161GLEdwards Jeffrey L · Port Orange, FLN161GTYellow Jacket Flying Club Inc · Atlanta, GAN161JLLuebben John R · Fayetteville, GAN161KMParis Air Inc · Vero Beach, FLN161LMays Stephen W · Carson City, NVN161MBKerf 25 Corp · Wilmington, DEN161MSBaker Weldon J · Lamesa, TXN161PTPilot Training Center LLC · Miami, FLN161RBJones Anthony M · Oak Point, TXN161REVornholt David · New Richmond, OHN161RKBreezy Flyers Aero Club · Kingston, TN
Back to AD 90-04-06 R1