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.
N82427Griffith Arthur Clark · Chattanooga, TNN82433Delong Erika D · Forest Lake, MNN82434Rounds Bonnie L · Zebulon, GAN82439Weigel John C · Natick, MAN82440Oliver Elizabeth L · Arlington, GAN82444Biggs Bill · Temple, TXN82447Erbey Jacob G · Hudson, WIN82458Barr Bruce A · Lander, WYN82462Malone Grady I · Loudon, TNN82463Gibson Romelle · Aberdeen, MSN82466Hrutkay Charles S · Scenery Hill, PAN82468Hemphill Holdings LLC · Hemphill, TXN82472Douglas Billy Ray · Brookston, TXN82478Salisbury Thomas · Coeymans Hollow, NYN82480Flugzeug LLC · Hanover, INN82484Grow David A · Gloucester Point, VAN82485Strom Kerry · Portal, NDN82489Behling James E · Cumberland, WIN82490Martin Nathaniel W · Wasilla, AKFirst renewal noticeN82496Mako Investments Lc · Lafayette, LAN82498Maedgen William L · Salado, TXN824SGAudenaert William N · Madison, ALN82501Feaster Christopher D · Richmond, INN82503Church David A · Schnecksville, PAN82506Church Sammie H · Statesville, NCN82510Swift Izak H · Fargo, NDN82512Reed Charles H · Shelbyville, KYN82515Pangelinan Regina Mafnas · Dublin, CAN82519Ross Elizabeth K · Schenectady, NYN825225 Pm Inc · Nampa, IDN82523Hardy John R · Wasilla, AKN82529Champ Aero LLC · Louisville, KYN82538Adkins Dwain L · Sycamore, ILN82540Valburg Lonnie H · Holton, KSN82541Tranby Wayne A · Fargo, NDN82543Janes Brenda Trustee · Shepherdsville, KYN82546Veillon Joseph B · Alexandria, LAN82548Registration Pending · Milwaukee, WIRegistration pendingN82551Brumfiel Joshua A · Hebron, KYN82558Leedom David L · Caney, OKN82559Sifsof Victor G · Dillingham, AKN82560Reynolds William J · Griffin, GAN82564Davis Richard · Reno, NVN82567Dagnon Paul A · Saint Paul, MNN82569Rinker Kraig G · Winlock, WAN82571Glastar LLC · Greenwood, MNN82572Debt Flying LLC · Holland, MIN82573Powell Michael D · Sealy, TXN82574Wendland Kenneth N · Big Timber, MTN82576Gainor Mark C · Milnor, ND
Back to AD 2000-25-02 R1