Skip to content

Registered aircraft · 680

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:89-26-06-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:89-26-06-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:89-26-06-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:89-26-06-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:89-26-06-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:89-26-06-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.

N663GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27568 N663UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27160 N664DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25012 N664UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29236 N665DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25013 N665UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29237 N666DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25034 N666UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29238 N667UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29239 N668DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25141 N668UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30024 N669AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25334 N669DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25142 N669UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30025 N6700Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30337 N6701Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30187 N6702Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30188 N6703DDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30234 N6704ZDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30396 N6705YDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30397 N6706QDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30422 N6707ADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30395 N6708DDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30480 N6709Delta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30481 N670AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25335 N670DNDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25331 N670UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29240 N6710EDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30482 N6711MDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30483 N6712BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30484 N67134United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29283 N6713YDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30777 N6714QDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30485 N6715CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30486 N6716CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30838 N67171Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30839 N671UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30026 N672DLDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25977 N672UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30027 N673AZAmazon.Com Services LLC · Seattle, WABuilt 2022 · S/N 67025 N673DLDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25978 N673UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 29241 N674DLDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25979 N674UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 29242 N675UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 29243 N676DLDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25981 N676UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30028 N677UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30029 N678DLDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25983 N68084Federal Express Corp · Memphis, TNS/N 25036

Back to AD 89-26-06 R1