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.
N3511ECircle S Aviation LLC · Starkville, MSN3512ERose Randy J · Egg Harbor, WIN3514EMulvania Rodney A · Linn, MON3518EWatters Robert K · Dwight, ILN3519EHousley William M · Jasper, ALN351TWebster Thomas F · Powell, OHN3521EZerovich Karl · Cortland, OHN3523EVintage Tailwheel LLC · Ocala, FLN3526EDill Terry L · Delphi, INN3528EBryant Albert · Tulsa, OKN3529EJohnson Galen G · Morrison, ILN3535DGreene Bryan V · Turlock, CAN3536ELindgren Darrell Allen · Wasilla, AKN3538EMayo Gary S · Bayboro, NCN3540ERoss John L · West Terre Haute, INN3542EDougherty Preston T · Vacaville, CAN3547EKimbrough Charles Ernest · Pine Mountain, GAN3551EFlite Five Inc · Kiowa, KSN355BGGrabhorn Bart · Scappoose, ORN355RBurges Matthew J · Lehigh Acres, FLN3562EIsbell David B · Fort Payne, ALN3565EVanzyverden Gregory · Plato, MON356JBBokash Greg · Bridgeton, NJN3573EBrodie James W · Lind, WAN3575ESkylink Aviation Inc · Florissant, MON3578EMears Robert C · Shreveport, LAN357ACBrown Eric J · Belle Plaine, MNN3581ESamson Mason H · Rives Junction, MIN3584EBurns Shane H · Waxahachie, TXN3585EDavenport Dewey D · Jamestown, OHN3587EHill Brianna L · Red Oak, IAN3588EFurstenberg John C · La Porte, TXN3589EAmsden William · Natchez, LAN3592EAudo Michael J · Portage, MIN3593EPusser Joshua D · Coats, NCN3595EMckee Ethella C · Green Castle, MON3596EKohler Donald Lw · Hernando, FLN359ACRunde Warren N · Concord, NHN359CAFly Inverted LLC · Brighton, MIN35BWCauthen Joe A · Canton, MSN35BYSuper D LLC · Broomfield, CON35FTGlenn Larry W · Bunn, NCN35MLNelson Aircraft Sales Inc · Minot, NDN35RXRight Rudder Flight Training LLC · La Verne, CAN35SGHoward William III · Wilson, NCN36008Bas Part Sales LLC · Greeley, CON36009Svanda Roger D · Tyndall, SDN36010Eskildsen Chris A · Connell, WAN36011Titus Larry E · Springview, NEN36013Jones Joseph D · Broken Arrow, OK
Back to AD 2000-25-02 R1