AD 90-04-06 R1
Registered aircraft · 68,377
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.
N577DPLustfeldt Gordon L · Normal, ILN577FCFlight Club · Middle River, MDN577FLMorsi Sameh M · Pomona, CAN577MBBlalock James M · Sheridan, ARN577SPTexas State Technical College · Waco, TXN577TMoore Eric C · Cave Creek, AZN5780FAces Aviation LLC · Laurel, MTN5780HPlane Fun Inc Tr Trustee · Snellville, GAN5780QMuegge Erik L · Keller, TXN5780WSmoyer Justin L · Slatington, PAN5780ZBergstrom Robert L · Amelia Court House, VAN5781FRegistered aircraftN5781QFranklin Mountain Group Corp · Nashville, TNN5781WPietras Aaron E · Franklin, INN5782FMission Aviators LLC · Spring, TXN5782HTomas Douglas J · East Troy, WIN5782JN5782j LLC · Myrtle Beach, SCN5782PPaviation LLC · Lewes, DEN5782QSkylions LLC · Wichita, KSN5782VDave Sheets And Sons Contracting Inc · Columbia City, INN5782WDavis Clinton · Baldwin City, KSN5783FBate Eric D · Vancouver BcN5783HBellas Bryan T · Geneva, OHN5783ULindberg Kyle J · Pahrump, NVN5783WDillard Joseph · Thaxton, MSN5783ZAlix Brian R · Valley Falls, NYN5784FCrocker James Fuller · Trussville, ALN5784HWright William J · Raeford, NCN5784QArias Raymond G · Wesley Chapel, FLN5784UMchenry Charles · Siloam Springs, ARN5785LVance Marc G · Canal Winchester, OHN5785PSmith Clyde R Jr · Lock Haven, PAN5785QSw Industry Inc · Wilmington, DEN5785UZanino James A · Sterling, MAN5785WLilu LLC · Siloam Springs, ARN57861Ferlaak James V · Elk River, MNN5786FPalazzi Michael A · Longmeadow, MAN5786HLynn Leroy D · New Carlisle, OHN5786QMartinez Todd P · Vacaville, CAN5786UCampbell Ashley H · Colorado Springs, CON5786WPowers Meranda M · Nampa, IDN5787BWilliams Thomas C · Fort Myers, FLN5787DWyoming Development LLC · Cheyenne, WYN5787HLagace Donald O · Augusta, MEN5787UCodreanu Octavian · Thorndale, PAFirst renewal noticeN5787WNewsome Robert K · Linwood, NCN5787ZFaust David E · Windber, PAN5788HMillar George B · Le Claire, IAN5788QMccabe David P · Tower, MNN5788WTech Flight Corp · South Hamilton, MA
Back to AD 90-04-06 R1