Skip to content

Registered aircraft · 1,335

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:99-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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:99-23-22-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.

N26215United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28775 N26226United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28935 N26232United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28942 N263LMVent Airlines Inc · Dover, DEBuilt 1994 · S/N 26603 N263SGAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 29263 N264RVHfa Specialty Acquisitions LLC · Boca Raton, FLBuilt 2002 · S/N 327 N270MFBank Of Utah Trustee · Salt Lake City, UTBuilt 1987 · S/N 509 N271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 189 N271LVSouthwest Airlines Co · Dallas, TXS/N 29090 N27205United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30577 N27213United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28773 N27239United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28951 N27246United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28956 N27722United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28789 N27724United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28791 N27733United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28800 N27734United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28949 N277ACBank Of Utah Trustee · Salt Lake City, UTS/N E2334 N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332 N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057 N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455 N282FRockland Aerospace Inc · Crofton, MDBuilt 1959 · S/N 1084 N285ACBank Of Utah Trustee · Salt Lake City, UTS/N E2307 N286FRockland Aerospace Inc · Crofton, MDBuilt 1960 · S/N 1146 N287KBCsds Asset Management LLC · Marana, AZBuilt 1987 · S/N 49768 N288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 148 N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467 N28DCMbogo Energy LLC · Boerne, TXBuilt 1994 · S/N 139 N290FAUmb Bank N A Trustee · Salt Lake City, UTS/N 29080 N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317 N291EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53039 N292EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53208 N293EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53209 N294EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53210 N295EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53211 N296EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53212 N29717United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28936 N297EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53213 N299PRMeregrass Inc · Dublin, TXBuilt 2000 · S/N 299 N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343 N301KHAeko Kula LLC DBA · Honolulu, HIBuilt 1995 · S/N 27904 N301NWAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33342 N301PAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31255 N302FLBank Of Utah Trustee · Salt Lake City, UTS/N 30072 N303KHNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1999 · S/N 25606 N303MPAir Cargo Services LLC · Miami, FLS/N 390 N303TWLogistic Air Inc · Reno, NVS/N 20116 N30501Dutchess Community College · Poughkeepsie, NYS/N 383 N305LRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 305 N305NXAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31253

Back to AD 99-23-22 R2