Skip to content

Registered aircraft · 896

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:85-14-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:85-14-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:85-14-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:85-14-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:85-14-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:85-14-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.

N827MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29705 N828MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29699 N829MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29700 N829WWHemisphere Aerospace Investments LLC · Waco, TXS/N 27503 N830MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29701 N831MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29702 N832MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29704 N833MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29706 N834ASAersale Inc · Coral Gables, FLS/N 28834 N834MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29707 N835MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29708 N836MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29709 N837MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29710 N838MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29711 N839MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29712 N840MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29718 N841MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29714 N842MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29715 N843MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29716 N844MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29717 N845MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29719 N858FTLogistic Air Inc · Reno, NVBuilt 1970 · S/N 20109 N874TWUnited States Government · Washington, DCBuilt 1989 · S/N 24524 N888LTAero Micronesia Inc DBA · Barrigada, GUBuilt 1992 · S/N 25441 N903ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 33096 N904ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 33097 N905NANational Aeronautics And Space Administration · Houston, TXBuilt 1970 · S/N 20107 N910FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25054 N910UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67980 N912UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67981 N913UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67982 N914UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67983 N915FDFederal Express Corp · Memphis, TNBuilt 1988 · S/N 24120 N915UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67984 N916UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67985 N917UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68363 N918UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68364 N919CAAc Spe 2 LLC · Orlando, FLBuilt 1991 · S/N 25302 N919UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68365 N920UPBoeing Co · Renton, WABuilt 2026 · S/N 68366 N921UPBoeing Co · Renton, WABuilt 2026 · S/N 68367 N922TSAero Micronesia Inc DBA · Barrigada, GUBuilt 1990 · S/N 24845 N922UPBoeing Co · Renton, WABuilt 2026 · S/N 68368 N923FDFederal Express Corp · Memphis, TNS/N 26266 N923UPBoeing Co · Renton, WABuilt 2026 · S/N 68369 N924FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26267 N924UPBoeing Co · Renton, WAS/N 68370 N925FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 27238 N925UPBoeing Co · Renton, WAS/N 70801 N926UPBoeing Co · Renton, WAS/N 70802

Back to AD 85-14-02 R2