Registered aircraft · 2,912

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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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.

N221LMTrans Executive Airlines Of Hawaii Inc · Honolulu, HIBuilt 1987 · S/N SH3722 N222NPAircraft Fidelity Corp Trustee · Dover, DES/N 245 N224NVSunrise Asset Management LLC · Las Vegas, NVS/N 1694 N225AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30434 N225NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25194 N225PGAero 7 LLC · Doral, FLS/N 25247 N227AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27448 N227CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 26327 N227LAK&A Advisors LLC · Wilmington, DEBuilt 1976 · S/N 193 N228DGKonair US LLC · Miami, FLS/N 128 N228NVSunrise Asset Management LLC · Las Vegas, NVBuilt 1997 · S/N 716 N229AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27059 N230ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3667 N230FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6773 N230NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2001 · S/N 1372 N231XCMojave Jet LLC · Nolensville, TNS/N 231 N232FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6838 N233AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29430 N233FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7095 N233NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2003 · S/N 2001 N234AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30436 N234HGAviation & Defense Inc · Calabasas, CAS/N 382-4211 N234LRDanish Jet Inc Trustee · Cheyenne, WYBuilt 1980 · S/N 300 N234MMWalt Disney World Co · Lake Buena Vista, FLBuilt 1963 · S/N 121 N235FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7272 N235NVSunrise Asset Management LLC · Las Vegas, NVS/N 1130 N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956 N236FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7389 N23707United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28768 N23708United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28769 N23721United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28940 N237CMCargo Aircraft Management Inc · Wilmington, OHS/N 25584 N238FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7458 N238NVUmb Bank Na Trustee · Salt Lake City, UTS/N 2133 N239AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27450 N239NVUmb Bank N A Trustee · Salt Lake City, UTS/N 2144 N24089Ploutz Lloyd · Modesto, CAS/N 20455 N241AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27451 N24202United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30429 N24211United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28771 N24212United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28772 N24224United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28933 N24320Museum Of Mountain Flying · Missoula, MTBuilt 1944 · S/N 20197 N244FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67549 N245ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35099 N245FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67548 N245NVSunrise Asset Management LLC · Las Vegas, NVS/N 1550 N246FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67547 N246NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7664 N24702United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28763

Back to AD 74-08-09 R2