AD 80-25-07 R1
Registered aircraft · 25,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: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.
N64543Rcr Aviation LLC · Mansfield, OHN64545Airplane And Drone Flight Instruction LLC · Windermere, FLN6454GRoberge James F · Waterville, MEN6454MStrickland Deirdre N · Atlanta, GAN6454QKyle Robert L · Clinton, OHN64556D & S Aviation LLC · Spring, TXN6455CPruett Steven H · Midland, TXN6455VCrown Flying Club Inc · Olathe, KSN6456PQuad City Area Flying Eagles · Milan, ILN6456QLeehey Studio LLC · Santa Monica, CAN6456VRosing David · Sunland, CAN64575N64575 LLC · Cheyenne, WYN6457DTristar Aviation Services LLC · Hendersonville, TNN6457QRegistered aircraftN6458LCentral Texas College · Killeen, TXN6458VWilson David P · Lumberton, TXN6459CBallair LLC · Dalhart, TXN6459ULinck Market Inc · Little Rock, ARN64608A S Air LLC · Lantana, FLN6460LRichmor Aviation Inc · Scotia, NYN6460MHillsboro Aero Academy LLC · Hillsboro, ORN6460QDel Gado Raul L · Victorville, CAN6460TDavey Douglas H · Worley, IDN6460UHayes Toby G · Idaho Falls, IDN64611Great North Air LLC · Shelburne, NHN64617Melbourne Flight Training LLC · Melbourne, FLN6461QGanos Christ · Brookfield, WIN6461VRegistered aircraftN6462DN2893e LLC · Reno, NVN6462QPlummer Joshua · Fort Mill, SCN6462UAnderton Roy · Colbert, OKN6462VVanbergen Shaun S · Ashland City, TNN6463GTeens-In-Flight Inc · Palm Coast, FLN6463QLyon Aviation Inc · Pittsfield, MAN6464DHoney B LLC · Hillsboro, ORN6464RChristiansen Aviation LLC · Wilmington, DEN6464USherman Stanley Robert · Altus, OKN6465QLeckrone Steven R Trustee · Mustang, OKN6465THurricane Corp · New York, NYN64664Szpak Michael W · Albany, GAN6466DValley River Leasing Inc · Murphy, NCN6466NHagan Joseph · Steward, ILN6466QSherrod Paul A Jr · Opelika, ALN64678Ocean Aviation Inc · Berlin, MDN6467ALouise Walters Enterprises · Malabar, FLN6467LHoc Services Inc · Homer, AKN64686Kadena Aero Club · Apo, APN6468DShorter Laurence K · Hinsdale, MAN6468FFlying Aces Aero Fleet Inc · Guyton, GAN6468ULi Yoi Y · Largo, FL
Back to AD 80-25-07 R1