Registered aircraft · 994

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:2001-22-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:2001-22-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:2001-22-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:2001-22-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:2001-22-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:2001-22-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.

N838MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29711 N839MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29712 N840KWAlta 777 LLC · Salt Lake City, UTS/N 32890 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 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 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 N923TRCareer Aviation Co Inc · Wilmington, DES/N 28923 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 N927FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 27220 N927UPBoeing Co · Renton, WAS/N 70803 N929UPBoeing Co · Renton, WAS/N 70804

Back to AD 2001-22-13