AD 2016-22-06
Registered aircraft · 467
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:2016-22-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-22-06')
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:2016-22-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-22-06') 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.
N268PALone Star Diamond Aerospace Inc · Rockwall, TXN269PAMcdonough Scott · Longboat Key, FLN269PSHarvey Specter Investments LLC · Marble Falls, TXN26ZTHuang Zitai · Frisco, TXN271CKSkipi Arres LLC · Lakewood, CON272MBYankee Lima One LLC · Bolingbrook, ILN273LATake Flight Aviation LLC · Montgomery, NYN274LABell Aviation LLC · Virginia Beach, VAN275SBAntelope Aircraft LLC · New Orleans, LAN276BLAspen Higher Learning Flight Academy Inc · Aspen, CON27CDGeneral Service Co Inc · Goldsboro, NCN294DMMarkquart Air LLC · Chippewa Falls, WIN295RAFlight Stars LLC · Prescott, AZN296SKAlf Ix LLC · Chicago, ILN297LAAdam Errington LLC · Vero Beach, FLN29MTVoyager29 Inc Trustee · Wilmington, DEN301MJEchowhiskey LLC · Troutman, NCN302EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN303ERDiamond Aircraft Sales U S A Inc · London OntarioN303SWSkywarrior Flight Training LLC · Pensacola, FLN304ERDiamond Aircraft Sales U S A Inc · London OntarioN304SWSkywarrior Flight Training LLC · Pensacola, FLN305EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN306EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN308EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN309EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN310TFTitan Enoch LLC · Amarillo, TXN311AFAspen Higher Learning Flight Academy Inc · Aspen, CON311EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN311LHWingsleasing LLC · Wichita, KSN312EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN312JAb Air LLC · Medley, FLN313EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN314EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN314KYElkhorn Creek Aviation LLC · Georgetown, KYN3150AOklahoma Aviation LLC · Bethany, OKN315PSMiller Drew · Gustine, TXN315XAJetnexa Thirteen LLC · Gilbert, AZN316EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN316LLift Aircraft LLC · Carmel, INN316PSSkyline Aviation Inc · San Angelo, TXN317PSDreams Take Flight LLC · Orlando, FLN318EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN318PSWalton Warren A · Kitty Hawk, NCN319EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN320AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN320EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN320WBWasp Creek Holdings LLC · Austin, TXN322EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN322PSRockhill Group Inc · Molino, FL
Back to AD 2016-22-06