Skip to content

Registered aircraft · 1,131

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:2016-22-13') 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-13') 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:2016-22-13')
    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-13')
  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-13')
  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-13')
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.

N474ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 40715 N475USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 33789 N477ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 40716 N477USUS Department Of Homeland Security · Arlington, VABuilt 2003 · S/N 33785 N478ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44105 N479ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 60576 N481ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44106 N483ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 36350 N486ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44107 N487ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44108 N491ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44109 N492ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44110 N493ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41727 N494ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41729 N495ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41728 N506ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35690 N508ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35691 N512ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39043 N513ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35192 N514ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35193 N516ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39044 N517ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35197 N518ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35693 N519ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 36482 N520ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 36481 N523ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 35194 N524ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35195 N525ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35692 N526ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35196 N527ASAlaska Airlines Inc · Seatac, WAS/N 35694 N528ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35695 N529ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 35198 N530ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 36578 N531ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 35199 N532ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 36346 N533ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35201 N53441United Airlines Inc · Chicago, ILS/N 30131 N53442United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33536 N534ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35202 N535ASAlaska Airlines Inc · Seattle, WABuilt 2011 · S/N 35200 N536ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 35203 N537ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 35204 N538ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41188 N54241United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28953 N546ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30022 N54711United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28782 N548ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30020 N551ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34593 N552ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34595 N553ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34594

Back to AD 2016-22-13