Skip to content

Registered aircraft · 826

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:89-07-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:89-07-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:89-07-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:89-07-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:89-07-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:89-07-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.

N442KHAircraft 28888 LLC · Lake Mary, FLBuilt 1998 · S/N 28888 N444HECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 23800 N465TWSierra American Corp · Wilmington, DES/N 23465 N467TWSierra American Corp · Wilmington, DES/N 23466 N471DSBoeing Co · Renton, WABuilt 2025 · S/N 68737 N475USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 33789 N477USUS Department Of Homeland Security · Arlington, VABuilt 2003 · S/N 33785 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 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 N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554 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

Back to AD 89-07-13