AD 80-25-07 R1
Registered aircraft · 25,369
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-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N63718Putnam Donald P · Orla, TXN6371QJones Stephen D · Pittsburg, TXN6372DHofmann LLC · Blauvelt, NYN6372QKelley David L · Vincent, OHN6372SHolt Richard M · Sierra Vista, AZN6374DWings Flight Enterprises Inc · Danville, KYN6374TPlane Fun Inc Tr Trustee · Snellville, GAN6375DXin Han Aviation LLC · Atwater, CAN6375HRound Engine Aero · Nashville, MIN6375QIngram Jeffrey C · Penn Valley, CAN63767Wings Over Texas Holdings LLC · Denton, TXN6376MMattingly Eddie D · Port Charlotte, FLN6376QMccallson Bailey · Bethel, AKN63772Petty Charles R Trustee · Hamilton, MTN6377BMarsicano Robert M · Danbury, CTN6377QBuntenbach Stefan · Port Orange, FLN6377TTango Romeo Golf LLC · Wilmington, DEN6378MFlowers Jonathan Barak · Kent, WAN6378NSilent Sea Acres LLC · Beaver Dam, WIN6379FHuffman Jacob M III · Burleson, TXN6379MRichmor Aviation Inc · Scotia, NYN6380DLawson Justin · Jeffersonville, KYN6380ECessna N6380e LLC · Spring Branch, TXN6380QBiederman Clifton E · Jasper, FLN6381NSutherland David D · Delta Junction, AKN6381QMelnykov Ivan · Aliso Viejo, CAN6382DSocal Aviation Inc · Eastvale, CAN6382NHamptonville Aviation LLC · Hamptonville, NCN6382QAerospace Trust Management LLC Trustee · Wilmington, DEN6382SNichols Daniel Alan · Haymarket, VAN6383FWilliams William C Jr · Houston, TXFirst renewal noticeN6383NCarino Jane L · Buckley, WAN6383TLetourneau David · Valencia, CAN63843Hillsboro Aero Academy LLC · Hillsboro, ORN6384DN2893e LLC · Reno, NVN6384NWaggener Chris E · Adelanto, CAN6384QFurleigh Dwight D · Tonica, ILN63852Richmor Aviation Inc · Scotia, NYN6385NDewitt Robert M · Maybee, MIN6385PBada Alfredo · Mcallen, TXN6386CBas Part Sales LLC · Greeley, CON6386ER M Aviation Inc · Lakeview, MIN6386TPaul Taylor Consulting LLC · Albuquerque, NMN6386VSaunders Andreas · Wake Forest, NCN6387BSparrow Hawk Aviation LLC · Moraine, OHN6387FMitich Nathan · Fort Worth, TXN6387NRobert Fuoss Inc · Draper, SDN6388DBdo Aviation LLC · Dallas, TXN6388NAugust Aero LLC · Kalispell, MTN6388QSchatz Brook J · Lewiston, ID
Back to AD 80-25-07 R1