Skip to content

Registered aircraft · 961

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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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:98-13-12-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.

N804TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1989 · S/N 23988 N806TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 27081 N807KWAlta 777 LLC · Salt Lake City, UTS/N 27638 N809TARhoades Aviation Inc · Honolulu, HIBuilt 1987 · S/N 23796 N810KWAlta 777 LLC · Salt Lake City, UTS/N 27639 N810TARhoades Aviation Inc · Honolulu, HIBuilt 1975 · S/N 21116 N811KWAlta 777 LLC · Salt Lake City, UTS/N 27656 N811TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1986 · S/N 23538 N813KWAlta 777 LLC · Salt Lake City, UTS/N 27641 N814KWAlta 777 LLC · Salt Lake City, UTS/N 28396 N815KWAlta 777 LLC · Salt Lake City, UTS/N 27640 N817KWAlta 777 LLC · Salt Lake City, UTS/N 27642 N818NHAersale Inc · Doral, FLBuilt 2000 · S/N 29311 N819KWAlta 777 LLC · Salt Lake City, UTS/N 27654 N820KWAlta 777 LLC · Salt Lake City, UTS/N 27655 N821AUBank Of Utah Trustee · Salt Lake City, UTS/N 24821 N822KWAlta 777 LLC · Salt Lake City, UTS/N 28532 N825KWEal Asset Holdings LLC · Kansas City, MOBuilt 2003 · S/N 32318 N826KWAlta 777 LLC · Salt Lake City, UTS/N 28521 N827KWAlta 777 LLC · Salt Lake City, UTS/N 28525 N829WWHemisphere Aerospace Investments LLC · Waco, TXS/N 27503 N830KWAlta 777 LLC · Salt Lake City, UTS/N 30870 N833KWAlta 777 LLC · Salt Lake City, UTS/N 30868 N834ASAersale Inc · Coral Gables, FLS/N 28834 N834KWAlta 777 LLC · Salt Lake City, UTS/N 32317 N840KWAlta 777 LLC · Salt Lake City, UTS/N 32890 N858FTLogistic Air Inc · Reno, NVBuilt 1970 · S/N 20109 N860DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29951 N862DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29734 N863DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29735 N864BCBoeing Aircraft Holding Co · Seattle, WAS/N 30871 N864DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29736 N865BCBoeing Aircraft Holding Co · Renton, WAS/N 30872 N865DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29737 N866DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29738 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

Back to AD 98-13-12 R1