Skip to content

Registered aircraft · 50

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:2020-05-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:2020-05-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:2020-05-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:2020-05-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:2020-05-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:2020-05-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.

N1073PTvpx Ars Inc Trustee · North Salt Lake, UTS/N 19000107 N108MPAircraft Propeller Service LLC · Lake Zurich, ILS/N 19000108 N111NHE190 Msn111 LLC · Dover, DEBuilt 2007 · S/N 19000111 N112BZBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000077 N114BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000092 N115BZWilmington Trust Co Trustee · Wilmington, DES/N 19000096 N116BZWilmington Trust Co Trustee · Wilmington, DES/N 19000101 N120BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000115 N126BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000124 N128BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000132 N133ABBank Of Utah Trustee · Salt Lake City, UTS/N 19000469 N143BZPetrus Regional One Msn 19000276 LLC · Dallas, TXS/N 19000276 N184JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000008 N190JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000011 N190MBBank Of Utah Trustee · Salt Lake City, UTS/N 19000524 N192JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000014 N193JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000017 N195ARBank Of Utah Trustee · Salt Lake City, UTS/N 19000154 N227GVBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 19000159 N260NAAircraft Propeller Service LLC · Lake Zurich, ILS/N 19000260 N266JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 19000054 N267JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000065 N273JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 19000073 N279JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000090 N281JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000103 N283JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000125 N284JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 19000144 N306JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 19000272 N309JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 19000289 N317JBWilmington Trust Company Trustee · Wilmington, DEBuilt 2010 · S/N 19000363 N318JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 19000364 N328JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 19000422 N329JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 19000433 N337JBAdvanced Air LLC · Statesville, NCBuilt 2011 · S/N 19000473 N339JBAdvanced Air LLC · Statesville, NCBuilt 2011 · S/N 19000490 N397NCWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 19000151 N402LBank Of Utah Trustee · Salt Lake City, UTS/N 19000585 N527AHLineage Asset Company LLC · Wilmington, DEBuilt 2016 · S/N 19000691 N529HGBank Of Utah Trustee · Salt Lake City, UTS/N 19000529 N556ELRegistered aircraftN-number assigned (import), not yet registeredS/N 19000556 N709AJBank Of Utah Trustee · Salt Lake City, UTS/N 19000313 N713TSCactus Jack Airlines LLC · Beverly Hills, CABuilt 2015 · S/N 19000632 N783MMMandalay Resort Group LLC · Las Vegas, NVBuilt 2016 · S/N 19000705 N785MMMirage Resorts LLC · Las Vegas, NVBuilt 2016 · S/N 19000709 N825ACBank Of Utah Trustee · Salt Lake City, UTS/N 19000575 N827ACBank Of Utah Trustee · Salt Lake City, UTS/N 19000588 N937TABank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 19000221 N956UWAerovision Aircraft Services LLC · Muskegon, MIBuilt 2008 · S/N 19000156 N957UWAerovision Aircraft Services LLC · Muskegon, MIBuilt 2008 · S/N 19000161 N958UWAerovision Aircraft Services LLC · Muskegon, MIBuilt 2008 · S/N 19000164

Back to AD 2020-05-21