AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N82578Moser Calvin · Milbank, SDN82579Weston Lee R · Lilliwaup, WAN82586Poklar Norman A · Mount Orab, OHN82589George James C · Lenoir, NCN82590Hubble Harley J · Gallipolis, OHN82594Four C Sons Inc · Kersey, CON82595Dragons Tail LLC · Midland, MIN82599Hayden Sarah Alison · Owensboro, KYN825DSBreckner Robert J · Burnsville, MNN825JSSchumann John · Vero Beach, FLN825MCC & M Aviation LLC · White Lake, MIN825RHNorthcutt Randy · Alpine, WYN82602Verzwyvelt Andrew W · Alexandria, LAN82603Spain Benjamin D · Opelika, ALN82609Screws Harlan D · Vernon, TXN82610Elliott John O · Lathrop, MON82611Brehmer Paul M · Eagle River, AKN82615Gebbert Larrell D · Victoria, TXN82620Debonair Consulting Inc · Wilmington, DEN82621Weeks Nancy H · Abilene, TXN82624Wagner Timothy D · Wheelersburg, OHN82625Weisberg Perry A · Minot, NDN82626Rinker Michael D · Martin, TNN82630Patridge Rodney · Big Spring, TXN82637Snow Carol A · Rattan, OKN82639Cloud Joe E · Kenai, AKN82643Hendrickson Gary A · Chico, CAN82649Napier Graydon R · Linton, INN82650Mjj Aircraft Inc · Wilmington, DEN82653Riggin Flight Service Inc · Madison, SDN82655Boatright Kyle W · Marietta, GAN82657Irwin Terry H · Gordonille, MON82658Kimbrough Dan M · Mc Minnville, TNN82660Stalls Matthew B · Denver, CON82662Fisher Douglas W · Holton, KSN82666Woode Denico · Fort Riley, KSN82672Duerkop Burnell · Rockland, WIN82677Walker Jeffrey P · Warwick, NYN82680Hoffman Edward C · Tarpon Springs, FLN82681Herold Dana R · Mcminnville, ORN82682Long Jory J · Lake Ozark, MON82686Boucher Kenneth G · Scotland, CTN82693Gould Allison L · Antrim, NHN82694Henderson Norman L · Bowling Green, MON82699Koering Henry Marvin · Fort Ripley, MNN82701Woldow Fredric A · Morton, ILN82703Duffy William J · Cincinnati, OHN82704Ferry Eugene M · Lander, WYN82705Couvillion Rickey J · Lafayette, LAN82707Specht Beth A · Sherwood, WI
Back to AD 2000-25-02 R1