Skip to content

Registered aircraft · 167

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

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:2014-16-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-16-21') ORDER BY n_number

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:2014-16-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-16-21')
  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:2014-16-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-16-21')
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.

N3200XRegistered aircraftBuilt 2009 · S/N 27 N333MZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 158 N343APN343ap LLC · Sandy, UTBuilt 2015 · S/N 265 N343MGCapital Transport LLC · West Palm Beach, FLBuilt 2014 · S/N 249 N347BDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 248 N360NFalcon 7x Msn 041 LLC · Fort Lauderdale, FLBuilt 2009 · S/N 041 N360PZLeipold Aircraft LLC · Racine, WIBuilt 2009 · S/N 037 N369CAJmsj Texas LLC · Houston, TXBuilt 2009 · S/N 087 N36EZGarden Air LLC · Short Hills, NJBuilt 2007 · S/N 31 N377EFDodson International Parts Inc · Rantoul, KSBuilt 2010 · S/N 101 N37VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 26 N388MBMb Ramble On LLC · Covington, LABuilt 2013 · S/N 222 N4144Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 199 N424JGLeconte LLC · Newport Beach, CABuilt 2013 · S/N 160 N4320CRegistered aircraftBuilt 2011 · S/N 151 N437FBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 513 N450TB8x LLC · Kalispell, MTBuilt 2025 · S/N 518 N458XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 524 N479WRegistered aircraftBuilt 2013 · S/N 217 N47FRBank Of Utah Owner Trustee · Salt Lake City, UTS/N 47 N48JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 049 N496ACRegistered aircraftBuilt 2013 · S/N 211 N4CEAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 2011 · S/N 116 N4MHN4mh Holdings LLC · Fort Lauderdale, FLS/N 34 N501PGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 218 N506BAAir Bahnik LLC · Oyster Bay, NYBuilt 2010 · S/N 115 N50NL50nl LLC · Newton, MABuilt 2016 · S/N 276 N510AN1906 LLC · Franklin Park, ILBuilt 2013 · S/N 141 N5161Vinod Air LLC · Santa Rosa, CABuilt 2013 · S/N 203 N542GPAviation Services The Fourth Inc Trustee · Wilmington, DEBuilt 2011 · S/N 107 N5577XAskari 7x LLC · Bellingham, WABuilt 2011 · S/N 102 N557PKSion Aviation LLC · Vail, COBuilt 2010 · S/N 98 N559AMCircle Around 1 LLC · New York, NYBuilt 2013 · S/N 206 N56CLAih II LLC · Valley, NEBuilt 2008 · S/N 003 N577CFJpc Falcon 1109 LLC · Naperville, ILBuilt 2011 · S/N 145 N57SNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 442 N585BVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 147 N606TZDuo Partners Inc · Scarsdale, NYBuilt 2013 · S/N 235 N60SNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 452 N616MPAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 2010 · S/N 67 N6258AAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 96 N626LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 177 N626ZEaglehawk LLC · Seattle, WABuilt 2012 · S/N 170 N62ASTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 172 N646NYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 130 N646YTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 154 N656FGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 483 N666ZLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 233 N66DDRegistered aircraftBuilt 2011 · S/N 153 N672BCMfi Aircraft Leasing IV LLC · Fort Lauderdale, FLBuilt 2017 · S/N 416

Back to AD 2014-16-21