Skip to content

Registered aircraft · 1,257

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-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:2000-12-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:2000-12-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:2000-12-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:2000-12-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:2000-12-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.

N454AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5454 N454UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1104 N455UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1105 N456UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1128 N457UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1146 N458UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1163 N459UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1192 N460UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1248 N461UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1266 N462UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1272 N463UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1282 N464UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1290 N465UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1341 N466UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1343 N467UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1359 N468UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1363 N469UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1409 N470UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1427 N471UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1432 N472UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1435 N473UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1469 N474UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1475 N475UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1495 N476UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1508 N477AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2013 · S/N 5477 N477UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1514 N478UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1533 N479UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1538 N480UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1555 N481AVAircol 21 · Wilmington, DEBuilt 2010 · S/N 4381 N481NANeptune Aviation Services Inc · Missoula, MTS/N 2662 N481UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1559 N482UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1584 N483UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1586 N484UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1609 N485UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1617 N4866UUnited Airlines Inc · Chicago, ILS/N 2404 N486UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1620 N487UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1669 N4888UBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3258 N488UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1680 N489UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1702 N4901UUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 2680 N490UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1728 N491UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1741 N492UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1755 N493UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1821 N494UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1840 N495UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1842 N496UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1845

Back to AD 2000-12-13