Skip to content

Registered aircraft · 249

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

N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064 N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525 N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670 N129TWLogistic Air Inc · Reno, NVBuilt 1976 · S/N 21141 N151ZUsda Forest Service · Boise, IDS/N SH3407 N158CLUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 58 N158JPAerotrust Services Corp Trustee · Wilmington, DES/N 53195 N164TSBank Of Utah Trustee · Salt Lake City, UTS/N 21119 N165TSBank Of Utah Trustee · Salt Lake City, UTS/N 21523 N177RAUnited States Government · Fort Belvoir, VABuilt 1982 · S/N 85 N185KJJah 2022a Saab340b Msn 185 LLC · Dallas, TXBuilt 1990 · S/N 340B-185 N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994 N218JPAerotrust Services Corp Trustee · Wilmington, DES/N 53305 N219KABank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B192 N220MJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-220 N221LMTrans Executive Airlines Of Hawaii Inc · Honolulu, HIBuilt 1987 · S/N SH3722 N253AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-253 N265JAAviation Inventory Resources Inc · Alvarado, TXS/N 340B-265 N266AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-266 N27XJPhoenix Air Group Inc · Cartersville, GABuilt 1985 · S/N 340A-027 N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057 N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455 N286AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-286 N287KBCsds Asset Management LLC · Marana, AZBuilt 1987 · S/N 49768 N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467 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 N294TLAviation Inventory Resources Inc · Alvarado, TXBuilt 1997 · S/N 340B-294 N295EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53211 N296EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53212 N297EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53213 N298AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-298 N303TWLogistic Air Inc · Reno, NVS/N 20116 N304AEBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 340B-304 N304AGBank Of Utah Trustee · Salt Lake City, UTS/N 340B-418 N304WWWin Win Aviation Inc · Wake Forest, NCS/N SH3413 N307AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-307 N31019Save A Connie Inc DBA · Kansas City, MOBuilt 1974 · S/N 193B-1066 N313AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-313 N3172Bank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 340B172 N317AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-317 N320AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-320 N323AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-323 N327AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 340B-427 N329AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-329 N331TBMassachusetts Institute Of Technology · Lexington, MABuilt 1992 · S/N 340B-331 N332AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-332 N336SABank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 340B-336

Back to AD 91-10-01