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.
N5600ECompton Francis B Jr · Marfa, TXN5600GChimera Air Inc · Maumee, OHN5600RBreland Gerald Monroe Sr · Bogalusa, LAN5601AOsceola Aerosport LLC · Osceola, WIN5601EMarshall Joseph · Uniontown, OHN5601JGoos Lynn A · Silver City, IAN5602ALooney Hubert · Florissant, MON5602TBerg William J · Aberdeen, SDN5603CBoulette Harris · School Craft, MIN5603EMullins Esten R · El Paso, TXN5603JMiller Duane A · Redlands, CAN5603RRegistered aircraftN5604EHarris Stephanie L · Marion, MSN5604JJohnson David A · Sunrise Beach, TXN5604RSkunda Robert J · Hebron, OHN5604TAndrews Jeremy R · Walker, MNN5605AKlase Robert · Greenville, TXN5605GMartinez Ivan A · Oro Valley, AZN5605JMajor Air LLC · Charleston, SCN5605RCostello John M · Wichita, KSN5606CCollins Florence D Miki · Lake Minchumina, AKFirst renewal noticeN5606GPinho Michel A · Santa Barbara, CAN5607AGilbirds William M · Kansas City, MON5608CGustafson Kurt E · Winchester, VAN5608EMyers Alex B · Oshkosh, WIN5609BWinkelman Ronald A · Chugiak, AKN5609TWestfall Gage T · Marietta, OKN560ABQuartermaster Growth LLC · Vashon, WAN560FASteffel Farms LLC · Olivia, MNN560MAKrauss Solutions LLC · Debary, FLN560SFAllen Adam W · Sutter Creek, CAN560SPProtea Group Management Services LLC · Carrollton, TXN560THLe Tourneau University · Longview, TXN560ZHeslin Jon P · Sutton, MAN5610ANielson Douglas W · East Troy, WIN5610EBenelli Matthew T · Sandwich, MAN5610GInternational Air Services Inc Trustee · Carson City, NVN5610JRael Pedro G · Los Lunas, NMN5611ALewis Christopher Michael · Troy, OHN5611JJr'S Auto Care Center Inc · Gualala, CAN5611RNordell Louis W · Watervliet, MIN5611TSale Reported · Lenexa, KSSale reportedN5612GNelson Daniel J · Ladd, ILN5612JNovember Aviation Corporation · Hobart, WAN5612RLoerke James S · John Day, ORN5612TLord David A · Mackay, IDN5613CHolliday Mark E · Lake Elmo, MNN5613ESuter Laurance · Livermore, CAN5613JMorgan Edward A · Buchanan Dam, TXN5613TJones Curtis DBA · Jacksonville, NC
Back to AD 79-10-14 R1