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.
N2545FJewell Anthony G · Reedley, CAN2546FLloyd Clee E · Canby, ORN2546GStambaugh Rex E · Westminster, CON2546ZClark Brent R · Layton, UTN2547EFour Seven Echo LLC · Lenexa, KSN2547FAysta Paul M · Embarrass, MNN2547ZLecompte Francesca · Lancaster, MAN2549FAgaliotis Paul E · San Martin, CAN2549ZBronson Aviation Industries LLC · Sharpsburg, GAN254VVBoney Grady · Rhine, GAN2550FOdom Richard · Williamson, GAN2551ZHobson Simon · Eagle River, AKN2552ESkoog Gerald D · Greencastle, INN2552FCarolina Warbirds LLC · Patuxent River, MDN2553BAdirondack Air LLC · Wilmington, DEN2555EMartino John F · Kingston, NYN2555FKluge Michael F · Chanhassen, MNN2556BPierson Janice R Trustee · Scio, ORN2557ELenz David · Boca Raton, FLN2558BLandstrom Derek C · Thomaston, GAN2558EHabedank Mark P · Twin Valley, MNN2558FTen High Flg Inc · Five Points, CARegistration revokedN2559BHelderman Justin W · Newton, NCN2559FHey Eric R · Childersburg, ALN255BRRice Bob J · Corning, ARN255SFKcsi Aerial Patrol Inc · Bakersfield, CAN255TJackson Travels LLC · Quitman, TXN2561FRoehl Ellen D · Conroe, TXN2561ZMcbride Steve · Shamong, NJN2562CDerrick Jeffery R · New Richmond, WIN2562ENewell Robert J Jr · Belleville, MIN2562FMans David A · Gruver, TXN2562ZMortvedt Arthur D Trustee · Manley Hot Springs, AKN2563ESill David E · New Era, MIN2563FHickey Michael · Honey Grove, TXN2564FFackender Jeremy R · Lincoln, ALN2567ELinder Arnold P · Grand Rapids, MNN2568EMackes Michael D · Gardnerville, NVN2569FStuart Philip · Tallahassee, FLN2570FDexter Fred H · Live Oak, FLN2572E2572e LLC · Newport, MEN2572ZRunia Jerry L · Estelline, SDN2573EGalipeau John M · Standish, MEN2574GScholl John D · Alexandria, MNN2574ZKeegan Ace LLC · Tampa, FLN2575EAlley Terry R · Augusta, KSN2575FAksarben Flying Club LLC · Bellevue, NEN2575ZDavis Mary G · Friendswood, TXN2576EOlear Inc · Evansville, INN2576FStefany Brian · Euless, TX
Back to AD 2000-25-02 R1