Skip to content

Registered aircraft · 1,270

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

N150UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5504 N151UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5513 N152UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5588 N153UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5594 N154TSFalcon Aviation Holdings LLC · Hawthorne, CABuilt 2002 · S/N 30515 N155UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5659 N15710United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28780 N15712United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28783 N15751United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29047 N161UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1403 N16217United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28777 N16234United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28946 N162UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1412 N162WCWca Holdings III LLC · Missoula, MTBuilt 1999 · S/N 30329 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 N17752United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29048 N17753United Airlines Inc · Chicago, ILBuilt 2002 · S/N 30463 N177XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 2836 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

Back to AD 2000-12-01