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.
N6979UGiles Forrest D · Springtown, TXN6979WCzygan Noel · Rapid River, MIN697CACoast Flight Training And Management Inc · Dallas, TXN697FCBlackhawk Holding Corp · Wilmington, DEN697FLAeroflyin Corp · Pembroke Pines, FLN697FTSilvey Michael Duane · Newhall, CAN697LHFf22 LLC · Scottsdale, AZN697NDSouth Dakota State University · Brookings, SDN697RBAerospace Trust Management LLC Trustee · Wilmington, DEN697TMilguard Aviation Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN697YAHorizon Flyers LLC · Kingsford, MIN6980JNulton Enterprises LLC · Johnstown, PAN6980QHulme Aviation LLC · Gilbert, AZN6980RRock Your Wings LLC · Litchfield, OHN6980UHarvard Air Taxi LLC · Andover, MAN6980VTenney Kenneth Lee Jr · Princeton, KYN6981BTownsend Monte A · Wasilla, AKN6981HAll2fly LLC · Atlanta, GAN6981WHammontree David M · Rickman, TNN6982FSale Reported · Palm Coast, FLSale reportedN6982UStanley Harrelson Mccall · Pepperell, MAN6982VTwardowski Przemyslaw · Pasadena, CAN6982WMoran Erick A · Orange, CAN6983BWiltz Paul E · Opelousas, LAN6983DGoebel William R · Rhome, TXN6983EBurkhardt Charles P Jr · Norco, CAN6983HWaddell Pap LLC · Friendswood, TXN6983JLaid Back Investment Holdings LLC · Cairo, GAN6983WTuttle James M · Newell, IAN6984BBig Q Aviation Corp · Helena, MTN6984KRjr Airdrome Inc · Dover, DEFirst renewal noticeN6984PEnglish John H · Pittsburg, TXN6984VEitzmann Bryce J · Clinton, ARN69856Lucci Giacinto A · Nashville, MIN6985DRegistration Pending · East Gull Lake, MNRegistration pendingN6985QOneal Joseph M · Mariposa, CAN6985RWard Chad E · Paducah, KYN6986QBennett Donald M · Burley, WAFirst renewal noticeN6986UNabors Ricky D · Valrico, FLN69874Land Sea Air Leasing Corp · Grants Pass, ORN6987BState Of Alaska · Kodiak, AKN6987DBorror Bryce C · Gerber, CAN6987J3 November 6 LLC · Old Bridge, NJN6987QSmith Casey W · Houlka, MSN6987ZWilliams Mark · Cumming, GAN6988JDamon Paul H · Brigham City, UTN6988PKubitz Wesley M · Laurel, MTN6988UKisthard James A · Roberts, MTN6988VGreenlee Matthew Steven · Arnold, CAN6988WLowe-Wing Aviation Inc · Wilmington, DE
Back to AD 90-04-06 R1