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.

N673WMWm Corporate Services Inc · Houston, TXBuilt 2018 · S/N 285 N674WMWm Corporate Services Inc · Houston, TXBuilt 2022 · S/N 300 N67EABel Air LLC · Green Bay, WIBuilt 2008 · S/N 30 N694PDPacific Dental Services LLC · Irvine, CABuilt 2013 · S/N 228 N700FNPivotal Consulting LLC · Phoenix, AZBuilt 2011 · S/N 133 N703MDMdjj Assets LLC · Houston, TXBuilt 2009 · S/N 73 N711PVEth Is Money Change My Mind LLC · Stuart, FLBuilt 2013 · S/N 219 N714KN15fx Trust · Wilmington, DEBuilt 2010 · S/N 100 N716CGBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 476 N720ABAlpha Bravo Leasing LLC · Wilmington, DES/N 62 N722AZGiostyle LLC · Napa, CABuilt 2010 · S/N 99 N73KTAmeritex Aviation LLC · Seguin, TXBuilt 2012 · S/N 146 N73VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 06 N744CGeneral Avileasing Inc · Wilmington, DEBuilt 2017 · S/N 424 N746HCDasher Air LLC · Dallas, TXS/N 176 N74JKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 136 N758PMFalcon 7x (Msn 58) LLC · Miami Beach, FLBuilt 2008 · S/N 58 N7707XLacob Ventures LLC · Woodside, CABuilt 2007 · S/N 16 N772JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 002 N777XVGsm Assets II LLC · Houston, TXBuilt 2010 · S/N 125 N780LMLiberty Media Corp · Englewood, COBuilt 2019 · S/N 291 N783SLSl Management LLC · Morristown, NJBuilt 2012 · S/N 169 N7JDVoice Of The Covenant Church Inc DBA · Destrehan, LABuilt 2008 · S/N 052 N7KBKkb Holdings LLC · Houston, TXBuilt 2012 · S/N 140 N7KMFaith Life International Inc · Sarasota, FLBuilt 2008 · S/N 53 N7XWallan Aviation Trust Co Trustee · Wichita, KSBuilt 2008 · S/N 33 N8000ERegistered aircraftBuilt 2008 · S/N 25 N805CCCcc 100 Aviation LLC · Wilmington, DEBuilt 2021 · S/N 297 N805PHPost Foods LLC · Chesterfield, MOBuilt 2011 · S/N 129 N808FABank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 040 N817XGacb Aviation LLC · Hasbrouck Heights, NJBuilt 2013 · S/N 208 N818TLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 195 N819BCMfi Aircraft Leasing LLC · Fort Lauderdale, FLBuilt 2011 · S/N 095 N8200ERegistered aircraftBuilt 2012 · S/N 148 N822LCValkyrie 8x LLC · Seattle, WABuilt 2022 · S/N 492 N82RPRich Aviation Inc · Buffalo, NYBuilt 2008 · S/N 35 N843GPGp Air Services Inc · Spring, TXBuilt 2011 · S/N 114 N843SUS Bank National Association Trustee · Hartford, CTBuilt 2013 · S/N 197 N848BCMfi Aircraft Leasing II LLC · Fort Lauderdale, FLBuilt 2010 · S/N 108 N8800ERegistered aircraftBuilt 2013 · S/N 210 N881MPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 436 N882MPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 421 N885XPacific Connection Inc · Dover, DEBuilt 2019 · S/N 450 N8889Rfp Air Inc · Manhasset, NYBuilt 2011 · S/N 112 N888DProgeny 3 Inc · Kirkland, WABuilt 2012 · S/N 164 N898ESSt Paul Holdings LLC · Denver, COBuilt 2008 · S/N 15 N8XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 514 N900DWWhite Lodging Leasing LLC · Merrillville, INBuilt 2008 · S/N 39 N900NB900nb Corp · Chicago, ILBuilt 2009 · S/N 74 N901SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 38

Back to AD 2014-16-21