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.
N446ERWingsleasing LLC · Wichita, KSN446SNWarren Dennis · Las Vegas, NVN446SPLam Capital Management LLC · Sheridan, WYN4470UBlack Kevin J · Edgewater, FLN4471RMurray Carol A · Hilo, HIN4471UCameron Schoessler Aviation LLC · Bliss, IDN4472BEdwards Christopher V · Seattle, WAN4472RFlyrite Aviation LLC · Fort Myers, FLN4473BBenedict Larry D · Dexter, NMN4473LWestbrook Lavelle D · Taylorsville, MSN4473RMiller Keith A · Reedy, WVN4473UChickasha Wings Inc · Chickasha, OKN4474LBlanco Andres A Socarras · Lajas, PRN4475LAlfonso Ramos · Dallas, TXN4476BRegistered aircraftN4476LP&N Corp · Marion, IAN4476UTowne Sheldon E · Whitefield, NHN4477BSpar Enterprises LLC · Warrensburg, MON4477LEdgin Jim · Aptos, CAN4477RDyer George C · Victor, MTN4478BMouse Jay F · Goldendale, WAN4478UGlaze Jess J · Chandler, AZN4479BBig Wing LLC · Delavan, MNN4479LGravenstede Nelson F · Newton, NJN4479RUp And Up Aviation LLC · Magnolia, TXN447CPCivil Air Patrol · Maxwell Afb, ALN447DKDecesare Lynnette · Charlotte, NCN447ERSilver Express DBA · Miami, FLN447ESRegistered aircraftN447WLM5-210c LLC · Castle Pines, CON4480RSoutheastern Minnesota Flying Club Inc · Rochester, MNN4482RBarxbar Aviation LLC · Mesa, AZN4483LRogers Ross E · Udall, KSN4483RRuf Timothy · Anchorage, AKN4484BThames James W · Florence, ALN4484LMifflintown Airport Aero Club Inc · Loysville, PAN4484UCox Walter W · Hale Center, TXN4485UMapes Peter B · Oscoda, MIN4486RAurora Aviation Lc · Pierce City, MON4486UTaylor Roger D · Paris, TNN4488RSmith Byron L · Bourbon, INN4488SMartens Paul A · Fairview, OKN4489BHarris Ryan A · Valley Cottage, NYN4489U237th Aero Squadron Inc · North St Paul, MNN448AFBeale Air Force Base Aero Club · Beale Afb, CAN448AKN448ak LLC · Helena, MTN448ALWheeler Alexa L · Tavernier, FLN448BBHawkflight LLC · Sugar Land, TXN448CPCivil Air Patrol · Maxwell Afb, ALN448ERAtp Aircraft 4 LLC · Wilmington, DE
Back to AD 79-10-14 R1