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.
N6317NMorton David J · Brooks, GAN6318NRiceland Aviaton Inc · Jennings, LAN6319NZatloukal Jan · Payette, IDN631ACKcsi Aerial Patrol Inc · Bakersfield, CAN631DMPlehn John C · Sandy Valley, NVN631MARexair Aircraft LLC · Naples, FLN631MPAircraft Guaranty Corp Trustee · Oklahoma City, OKN6322NThelander Edwin · Bristol, MEN6323NRay Raymond Heath · Louisville, KYN6324NSimmons Rita B · Saint George, MEN632KMouzakis Shaun Kevin II · Johnstown, CON6331NMartens Air Service LLC · North Platte, NEN6338NCole Justin L · Mendon, NYN63394Perkins Robert A · New Richmond, WIN633ACJ&S Recreational Inc · Evansville, INN633LLetourneau University · Longview, TXN6341NDexter Fred H · Live Oak, FLN6343NHenderson Scott · Cocoa Beach, FLN6344NPlane Fun Inc Tr Trustee · Snellville, GAN6345NColeman Darryl W · Fayetteville, GAN6345XPingston Robert D · Morrice, MIN6346NYoung Marlon V · Santa Rosa, CAN63486Precissi John A · Stockton, CAN63488Quinn Timothy L · Tujunga, CAN6348NNelson Spraying Service Inc · Chester, MTN634LLetourneau University · Longview, TXN6350NLynn Robert W · Independence, WVN6352NGilbreath Tony C DBA · Olustee, OKN6357NHamlin Andrew James · Fairbanks, AKN6358NLarson Lynn R · Fargo, NDN6362NGoodwin David C · Boulder, WYN6365NSouth Dakota State University · Brookings, SDN6366NCarlson Eric S · Kodiak, AKN6368NS&S Aviation LLC · Morse, LAN6369NEberhart Royce R · Covington, GAN636DBVectored Solutions Inc · Everett, WAN6378NSilent Sea Acres LLC · Beaver Dam, WIN6381NSutherland David D · Delta Junction, AKN6382NHamptonville Aviation LLC · Hamptonville, NCN6383NCarino Jane L · Buckley, WAN6384NWaggener Chris E · Adelanto, CAN6385NDewitt Robert M · Maybee, MIN6385VChamp Flyers Of Va LLC · Glen Allen, VAN6387NRobert Fuoss Inc · Draper, SDN6388NAugust Aero LLC · Kalispell, MTN6389NLedbetter Jason · Ypsilanti, MIN6392NPritchett Joe H · Dyersburg, TNN6393NCulpeper Aviation LLC · Queen Creek, AZN6396NChampion Aircraft LLC · Valdosta, GAN6397NLafleur Gregory J · Eunice, LA
Back to AD 2000-25-02 R1