AD 80-25-02 R2
Registered aircraft · 6,349
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:80-25-02-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
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:80-25-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2') 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.
N5321ZAyers Mark T · Whitney, TXN5322ZHall Rodney R · Portsmouth, VAN5325HAdams William Carter · Macon, GAN5326HVan Zant Timothy L · Nenana, AKN5327HNass Michael F · Clinton, IAN5329ZCline Wade J · Reno, NVN532RSZacherl Randall L · Indiana, PAN53311Barksdale Air Racing LLC · Conroe, TXN5331ZDaye Jeffrey E · Salisbury, NCN5332ZGulley Mark E · Guntersville, ALN5333HMcchristian Jerome M · Granbury, TXN5333ZRegistration Pending · Fort Worth, TXRegistration pendingN5334ZUeeck Robert D · Minnetonka, MNN5335PFlying Vikings Inc · Hayward, CAN5335ZGiber Kristofor D · Manvel, TXN5337HOder Kenneth L · Taylorsville, KYN5337LFather Son Ing LLC · Wilmington, DEN5337PHanson David J · Elgin, TXN5337ZBrown Estates Aviation LLC · Fresno, CAN53380Haltom Gary D · Alva, OKN5339BFiebig Howard J · Sebewaing, MIN5340HHarmon Michael N · Ankeny, IAN5342PSp Airparts LLC · Moscow, IDN5343HDawson Guy · Lake Clear, NYN5343ZGolden Age Aeroworks LLC · Lone Rock, WIN5344BJohn Annin LLC · Fenton, MON5344MPinger Kevin R · Palo Alto, CAN5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LAN5348BBowers Curt E · Jennings, LAN5348ZDavis Robert D · Shongaloo, LAN5350MNewsom Bearden And Cobb Inc DBA · Lubbock, TXN5350PChristiansen Aviation LLC · Wilmington, DEN5350ZAgalotis Paul E · San Martin, CAN5351LHillsboro Aero Academy LLC · Hillsboro, ORN5351PPointair Aviation Inc · Port Jeff Sta, NYN5351ZGostola Thomas · Fairmount, INN5352ZMcdougall Michael D · Caldwell, IDN5353HDe Nunzio Arnold J · Ballard, CAN5354ZManson Timothy C · New Gloucester, MEN5355PPittsburgh Pilot Training LLC · Bethel Park, PAN5355QGorge Winds Aviation Inc · Fairview, ORN5355ZWatts Carrie L · Hazen, NVN5356HMurphey Stephen B · Lynchburg, SCN5357HRichmor Aviation Inc · Hudson, NYN5357PSunrise Aviation Inc · Ormond Beach, FLN5358HDaniels Scott M · Litchfield, MEN5359ZSale Reported · Crozet, VASale reportedN535FLJestes Monte G · Stillwater, OKN535TCNichols Craig J · Andover, MNN5360HEastern Stearman Inc Trustee · Leesburg, VA
Back to AD 80-25-02 R2