Skip to content

Registered aircraft · 1,118

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:90-12-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-12-11-R1') 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:90-12-11-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-12-11-R1')
  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:90-12-11-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-12-11-R1')
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.

N406CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1997 · S/N 28752 N409YKAircraft 25859 LLC · Lake Mary, FLBuilt 1993 · S/N 25859 N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284 N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353 N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735 N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045 N440KHAircraft 28889 LLC · Lake Mary, FLBuilt 1998 · S/N 28889 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 N48127United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28968 N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304 N503UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24624 N506ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35690 N507YVBank Of Utah Trustee · Salt Lake City, UTS/N 24607 N508ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35691 N508UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24744 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 N518UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24871 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 N539USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26486 N540USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26487 N541USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26488 N54241United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28953

Back to AD 90-12-11 R1