Skip to content

Registered aircraft · 709

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:97-09-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-09-02-R2') 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:97-09-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-09-02-R2')
  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:97-09-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-09-02-R2')
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.

N163USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1417 N165USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1431 N16701United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28762 N16703United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28764 N16709United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28779 N16713United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28784 N16732United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28948 N167USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1442 N169UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1455 N170USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1462 N171USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1465 N17229Umb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 28793 N17233United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28943 N17244United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28954 N17245United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28955 N172USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1472 N173USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1481 N176UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1499 N17719United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28938 N17730United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28798 N178USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1519 N179UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1521 N180USWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1525 N18220United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28929 N18223United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28932 N182UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1536 N183UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1539 N184USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1651 N185UWAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1666 N186USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1701 N187USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1704 N188USAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 1724 N189UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1425 N190UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1436 N191UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1447 N192UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1496 N200WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32482 N201LVSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 29854 N203WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32483 N204WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 29855 N205WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34010 N206WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34011 N207WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34012 N208WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 29856 N209WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32484 N210WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34162 N211WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34163 N212WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32485 N213WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34217 N214WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32486

Back to AD 97-09-02 R2