AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N710LULiberty University School Of Aeronautics · Lynchburg, VAN710MHK Bay Air LLC · Homer, AKN710RRMulcahy Michael T · Perris, CAN710SATextron Aviation Inc · Wichita, KSN710SPElite Approach LLC · Chesterfield, MON710TDDuke Ray J · Oak Point, TXN710TRSln Aviation LLC · Salina, KSN710WGAger Brandon Reno · Craig, CON71107Jrf Enterprises LLC · Salem, ORN7110QLawson Virgil · Sylvar Grove, KSN7110TWright Donald E · Greensboro, NCN71114Aeropaws Aviation LLC · Front Royal, VAN71118Taf Aerial Services LLC · Beeville, TXN7111ABurgess Fred P · Titusville, FLN7111MPlatt Aaron Eugene · Heppner, ORN7111NAirline Transport Professionals Corp Of USA · Wilmington, DEN7111SDemaio John · Dillwyn, VAN7111TMesseder Thomas Alan Jr · Fredericksburg, VAN7111WBetter Living Aviation Inc · Wilmington, DEN7111XGoodwin Joseph N · Grass Valley, CAN71121Karmy Jeffrey R · Medford, ORN71123Debusk Eric M · Columbus, INN71124N71124 LLC · Waunakee, WIN71126Overturf Andrew · Franklin, WIN7112EAircraft Structural Repair Inc · Hamilton, MTN7112FHurst Richard H · Lometa, TXN7112GHooper Walter E III · Spring City, TNN7112SBridges Robert S · Friendswood, TXN7112XKoplitz Wesley D · Oshkosh, WIN7113Rotter Shane F · Olympia, WAN71132Neale Bruce G · Joppa, ALN711333 F Aviation LLC · Norwood, LAN71136Jones Harper L II · Pendleton, ORN7113ATrail Richard L · Mccook, NEN7113MOgle Tyler E · Eufaula, OKFirst renewal noticeN7113QMiles Michael G · Hillsborough, NCN71149Skydive Harbor Springs Inc · Charlevoix, MIN7114ETlm Properties LLC · Gladewater, TXN7114FWernecke Thomas C · Southfield, MIN7114MJohnson Mark A · Bellevue, IDN7114QSass Kenneth · Charlotte, NCN7114SMuinos Jose M · York, PAN7114TMeyer Andrew J · Carter, SDN7114XKnutson Wayne R · Tioga, NDN7115ARothenbusch Michael G · Tampa, FLN7115MSatanta Flying Service Inc · Satanta, KSN7115QMaggart Kenneth R · Lutz, FLN7115T172 Club LLC · Olalla, WAN71164Core Jerry M · Bishop, CAN71165Aggie Aero Enterprises LLC · Cleveland, TX
Back to AD 79-10-14 R1