Skip to content

Registered aircraft · 808

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:2003-20-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:2003-20-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:2003-20-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:2003-20-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:2003-20-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:2003-20-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.

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 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 N556ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35175 N557ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35176 N558ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35177 N559ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35178 N560ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35179 N562ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35091 N563ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35180 N563WNWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 34296 N564ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35103 N565ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35181 N566ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35182 N568ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35183 N569ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35184 N570ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35185 N571ASUmb Bank Na Trustee · Salt Lake City, UTS/N 32904 N577ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35186 N579ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35187 N581ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35188 N583ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35681 N584ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35682 N585ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35683 N586ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35189

Back to AD 2003-20-13