Skip to content

Registered aircraft · 783

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:94-06-04') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-06-04') 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:94-06-04')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-06-04')
  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:94-06-04')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-06-04')
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.

N102UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 0844 N103USUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0861 N104UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0863 N105UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0868 N107USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1052 N108UCHot Springs Flyers Inc · Covington, LABuilt 1979 · S/N 31T-8020018 N108UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1061 N109UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1065 N110UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1112 N111JFJoyce Aviation Inc · Winston Salem, NCBuilt 1981 · S/N 31T8120012 N111USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1114 N112USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1134 N114BAAustin Bill DBA · Sparta, TNS/N 42-8001027 N114UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1148 N115BMAshland Water Group · Ashland, OHBuilt 1982 · S/N 31T-8120053 N115PCDodson International Parts Inc · Pelkie, MIBuilt 1977 · S/N 31T-7820001 N117UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1224 N1183GC A R Lease Corp · Brentwood, TNBuilt 1979 · S/N 31T-7920086 N118USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1264 N118WCHalair Inc · Diablo, CABuilt 1979 · S/N 31T-8020020 N119USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1268 N120UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29166 N121LHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 425501049 N121UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1294 N122UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29168 N122USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1298 N123UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1310 N124USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1314 N125UWAmerican Airlines Inc · Forth Worth, TXBuilt 2009 · S/N 4086 N126UWAmerican Airlines Inc · Forth Worth, TXBuilt 2009 · S/N 4149 N127UWAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 4202 N128UWAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 4242 N131PCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 31T-7820009 N139CSCheyenne Flight Group LLC · Wallingford, CTS/N 31T-8120004 N141TCEhs Aircraft LLC · Wilmington, DEBuilt 1984 · S/N 42-5501021 N144PLCatskill Transportation LLC · Kingston, NYBuilt 1984 · S/N 42-5527014 N14TNGonzalez-Ruiz Antonio R · Mountain Brk, ALBuilt 1981 · S/N 31T-8120060 N1523Msn 1523 LLC · San Diego, CABuilt 2001 · S/N 1523 N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085 N155MCWhite Bay Aviation LLC · Corpus Christi, TXBuilt 1978 · S/N 31T-7820069 N158ASAersale Inc · Coral Gables, FLS/N 1578 N158MHMansfield Heliflight Inc · Milton, VTS/N 42-5527006 N171JPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 31T-7720028 N171UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24322 N178SGTango Tango LLC · Naples, FLS/N 31T-8020044 N179CJIal Corp · Lewes, DES/N 176 N181DCAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedS/N 31T-7520026 N182UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25279 N184SKBank Of Utah Trustee · Salt Lake City, UTS/N 28284 N184WWRoyal Air Freight Inc · Waterford, MIBuilt 1976 · S/N 352

Back to AD 94-06-04