Skip to content

Registered aircraft · 562

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:2016-08-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:2016-08-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:2016-08-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:2016-08-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:2016-08-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:2016-08-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.

N4304Bank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4304 N430UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 568 N431UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 571 N432UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 587 N433UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 589 N434UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 592 N435UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 613 N436UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 638 N437UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 655 N438UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 678 N439UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 683 N440UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 702 N441UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 751 N442UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 780 N443UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 820 N444UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 824 N445UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 826 N446AVAircol 11 · Wilmington, DEBuilt 2009 · S/N 4046 N446UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 834 N447UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 836 N448UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 842 N449UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 851 N451AVAircol 12 · Wilmington, DEBuilt 2009 · S/N 4051 N451UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 865 N452UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 0955 N453UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1001 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

Back to AD 2016-08-13