AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N5962QNewell Robert T · Angel Fire, NMN5963QKatz Matthew · Los Angeles, CAN5964QLin Andrew Hsia · Huntingtown, MDN5966QFarwell Jason E · Lansing, KSN5968QChess House LLC · Canton, SDN5969QAbdelsalam Moustafa Gamal · Buena Park, CAN596JRWilliams David J · San Francisco, CAN5970QYeager Robert Allen · Oregon City, ORN5973QFarias Gerardo M · Panama City Beach, FLN5974QTaylor Timothy T · Quitman, ARFirst renewal noticeN5976EFunkhouser Dennis E · Fredericksburg, VAN5976QEscobar Timothy · San Antonio, TXN5978QBauer Jared R · Sugar City, CON5979QBlount Aviation LLC · Metairie, LAN597CAWest Wind Farm Inc · Camarillo, CAN597CMAerospace Trust Managment LLC Owner Trustee · Wilmington, DEN597DMBrandon Air LLC · Valley Stream, NYN597MBBrandon Air LLC · Valley Stream, NYN597NDNicholas James Esch · Cedar Rapids, IAN597TTTerrell David R · Smithville, TNN5983JIlarraza Gilberto C · Sabana Hoyos, PRN5983MPhilipp Michael W · Thief River Falls, MNN5984QSlow Walkin Barnstormers LLC · Frostproof, FLN5985QInderkummen Jean Pierre · Gulfport, MSFirst renewal noticeN5986QFord Christopher D · Brunswick, GAN5987GSchwend Brian · Forsyth, MTN5987QHardesty William A · San Diego, CAN5988QLynn Seth D · Killeen, TXN5989QPressley Brent DBA · Morristown, TNN598BGSamuel James · College Station, TXN5990EManeuvering Speed Inc · Wilmington, DEN5990QShowman Benjamin J · Danville, ALN5991QBain Douglas D · Vega, TXN5992QFriday Ryan M · Elizabeth, PAN5993ETss Flying Club Inc · Bethesda, MDN5993QDeley Mike · Menifee, CAN5995QFangmeier Benjamin A · Strasburg, CON599CMMscm Partners LLC · Fairfield, TXN599DKEngler Jerry J · Kerrville, TXN59ACWatson David A · San Jose, CAN59BJWalser Air LLC · Warwick, RIN59LAAlphin Lewis Jackson · Mount Olive, NCN59MSSojka Michael J · Bainbridge, INN59PGStone Aviation Holdings LLC · Myrtle Beach, SCN59PHSeider Jason · Dallas, TXN59VLKelley Aircraft LLC · Weyers Cave, VAN59WDHorner Michael W · Manakin Sabot, VAN59WLHerrmann Mark D · Dillingham, AKN5AKHackler Tara Cole · Bend, ORN5BJLinrud Michael A · Velva, ND
Back to AD 80-25-07 R1