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.

N104MTTayberry Montana LLC · Belgrade, MTBuilt 2008 · S/N 55 N10DYPacific Trade Winds Aviation LLC · Newark, DES/N 121 N111HZSkyhigh 7x LLC · Chicago, ILBuilt 2011 · S/N 137 N114BDBlack Diamond Aviation Group LLC · Greenwich, CTBuilt 2009 · S/N 42 N123KH485 Industrial LLC · New York, NYBuilt 2013 · S/N 194 N128SKEcho Matrix LLC · Bentonville, ARBuilt 2019 · S/N 473 N12MWDaggett Investment Corporation LLC · Teterboro, NJBuilt 2021 · S/N 196 N138BRegistered aircraftBuilt 2009 · S/N 89 N143REAvo Airlines LLC · North Palm Beach, FLBuilt 2007 · S/N 13 N150BCBrc Transit LLC · Salem, ORBuilt 2010 · S/N 103 N16HACh Logistics LLC · Belgrade, MTBuilt 2011 · S/N 132 N171EXSky River Consulting LLC · Honolulu, HIBuilt 2008 · S/N 24 N173CNPnc Bank Na · Boise, IDBuilt 2012 · S/N 173 N179CGeneral Avileasing Inc · Wilmington, DEBuilt 2023 · S/N 502 N17XFCargo Solution Express Inc · Fontana, CABuilt 2007 · S/N 18 N1838SRegistered aircraftBuilt 2011 · S/N 111 N1898BUS Bank Na Trustee · Boston, MABuilt 2017 · S/N 433 N18MVTransnet Aviation Group LLC · Morristown, NJBuilt 2009 · S/N 75 N191MDDassault Falcon Jet Corp · Little Ferry, NJS/N 532 N191MMWorkday Inc · Pleasanton, CABuilt 2012 · S/N 180 N191MWPegasus Viii LLC · Incline Village, NVBuilt 2020 · S/N 477 N1933GGlazers Inc · Dallas, TXBuilt 2009 · S/N 088 N19VVWind And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2023 · S/N 503 N1AZWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 167 N1SKlc 158 LLC · Dallas, TXBuilt 2016 · S/N 415 N2016ANj Leasing 1224 LLC · Phoenix, AZBuilt 2007 · S/N 7 N2025Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 510 N221HJWisc LLC · New York, NYBuilt 2008 · S/N 19 N2239XUaml Corp · Wilmington, DEBuilt 2020 · S/N 479 N227KGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 511 N228APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 163 N234KHCreekside Logistics LLC · Salt Lake City, UTBuilt 2013 · S/N 234 N237XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 64 N244JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 244 N247GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5 N250LGUim Aircraft LLC · Englewood, COBuilt 2008 · S/N 12 N258XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 495 N263AMarmon Group LLC · Chicago, ILBuilt 2015 · S/N 263 N26HNEaglestar LLC · Monsey, NYBuilt 2012 · S/N 152 N270LBBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2025 · S/N 519 N281MMDb Aviation Holdings III LLC · Boca Raton, FLS/N 224 N294XU S Bank Na · Marshall, MNBuilt 2021 · S/N 294 N300CRCrane Company · Stamford, CTBuilt 2007 · S/N 29 N302FJVincennes Air LLC · Racine, WIBuilt 2009 · S/N 084 N302MLNorthwestern Mutual Life Insurance Co · Milwaukee, WIBuilt 2017 · S/N 281 N307LCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 23 N307PSSafely Kept LLC · Wilmington, DEBuilt 2014 · S/N 241 N30LBRegistered aircraftBuilt 2016 · S/N 280 N318CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 444 N318SKDassault Falcon Jet Corp · Little Ferry, NJBuilt 2010 · S/N 82

Back to AD 2014-16-21