AD 2000-25-02 R1
Registered aircraft · 7,561
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.
N2300EKilo Oscar LLC · Jupiter, FLN2301ELegler Michael D DBA · Webster, MNN2302ECollier Christopher S · Portage, MIN2304EHeitz John · Manvel, TXN2307EAbel Brandon R · Henderson, NVN230EELumley William B · Delray Beach, FLN230HTBurns Robert A · Fort Myers, FLN230MAParker-Omalley Corp · Chatham, NYN2315EMorton Dennis D DBA · La Harpe, ILN2316EDaviss Joseph A · Sylacauga, ALN2317EDoell John Homer · Elfrida, AZN2318EAir Giblinski LLC · Sedgwick, KSN231CCRegistration Pending · Sand Lake, MIRegistration pendingN231PMBernard Raymond C · Melba, IDN2324EBrown Craig D · Stanton, MIFirst renewal noticeN2327EZubeck Robert E · Emery, SDN232WMFilkins Barbara · Fillmore, CAN2334ESale Reported · Warren, OHSale reportedN2337EWhidby Richard L · N Myrtle Beach, SCN2338EAllen Timothy J · East Kingston, NHN233DPProp 2 Fox LLC · Hudson, OHN233SFSale Reported · Wakarusa, INSale reportedN2343EFly Greater Breezewood LLC · Clearville, PAN2344EPage Wayne Byron · Rochelle, ILN2348EBeck Milo H · Chandler, AZFirst renewal noticeN2349EWhitehawk Aviation LLC · Sanford, NCN234BAJohnson Alan Lee · Pikeville, KYN234HBLentini Christopher · Ardmore, OKN234RATom Eaton Consulting LLC · West Sacramento, CAN234SFDriscoll David A · Savannah, TNN2353ERotenberry Paul G · Mount Juliet, TNN235ACLetourneau University · Longview, TXN235SAJkt LLC · Douglas, WYN2363EBlack Jeffrey P · Hartselle, ALN2367ERegistration Pending · Mannington, WVRegistration pendingN2369EHayton James B · Sedro Woolley, WAN236JTRecord John · Apison, TNN2372EHulboy Jeffrey K · Churubusco, INN2375EFletcher Stephen J · Labelle, FLN2379ESchoonmaker Michael D · Alder Creek, NYN2383ELord Edward J · North Conway, NHN2384EMcconnaughhay Anthony B · Jacksonville, ARN2385EAdkins Jonathan T · Belvidere, ILN2387ERogers Gary L · Enid, OKN2388ESell Mark R · Woodbury, PAN238DMCopeland Gary L · Williamsburg, MIN2390YStrong James R · Williamsville, NYN2394ELaird Charles L IV · Adelanto, CAN239LLLloyd Land Plane V LLC · Brighton, CON239SFLuke Skywalker 23 LLC · Los Altos, CA
Back to AD 2000-25-02 R1