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.
N3997EStrahan Ronald R · Girard, KSN3998EOchsenbauer David J DBA · Ashland, WIN3999YSlyman David F · Inver Grove, MNN399BCParadox Aviation LLC · Whiting, IAN399BZBerjon Adventures LLC · Evergreen, CON39DBKwasinski Mark W · Kalamazoo, MIN39JLLundberg Jonathan S · Fayetteville, TNN39LTGeorgia Forestry Commission · Macon, GAN3BNHansen Warren K · Bozeman, MTN3EVDuncan John C · Gastonia, NCN3FHScarborough Alex C · Lubbock, TXN3JKPagenkopf Joseph C · Juneau, AKN3JZFreel Michael R · Cedarville, MIN3PBBendigo Paul L · Reading, PAN3RJB&B Transport Inc · Omaha, NEN3VXCoriell Lynn V · Columbus, OHN3YBMonroe Andrew P · Reno, NVN4000ESweeney Brett D · Anchorage, AKN4003EKnight Aaron P · Marion, INN4008AJuniata Valley Rv · Mifflintown, PAN4009BOoi Lucy M · Catlett, VAN400ABFlydallasbay LLC · Soddy Daisy, TNFirst renewal noticeN400HWHotel Whiskey LLC · Sylvania, OHN400KBArrowhead Circle Leasing LLC · Cedar City, UTN400VWSpuza Dan D · Sanger, TXN400WHHorrigan William Jr · Roxbury, CTN4012EFogle Timothy G · Lindsay, TXN4015BFletcher John G · Diamondhead, MSN4015ESeefeldt Richard K · Denver, CON40178Schuh Randy G · Williams, MNN4018BAven Michael R · Yorba Linda, CAN4019BKapellair LLC · Wickenburg, AZN4019EParker Thomas L Jr · Mount Vernon, ARN401ADAlexander Brad K · Melissa, TXN4022EGhl Air LLC · Ames, IAN4027EGrimshaw Nicholas A · Galt, CAN4031EMathis Gary A · Gonvick, MNN4033ECongdon Carl J · Manley, AKN4034EAdams Thomas D · Marathon, NYN4035EMurray Richard H · Celina, OHN4038ELerol Dustin C · Floodwood, MNN4040AShifrin Salvatore J · Windham, CTN4045EEwbank Martha C · Fairport, NYN4046EKnutson Wayne R · Thompson, NDFirst renewal noticeN4049EWilcox Darrol A · Nenana, AKN404JEMedia Stew LLC · Carson City, NVN4053EMacveigh Craig A · New Carlisle, OHN4057ESingleton Bruce W · Grafton, OHN405RCWaterman David N · Amery, WIN4060EValez Jay Daniel · North Branch, MN
Back to AD 2000-25-02 R1