Registered aircraft · 2,913

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.

N399DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30379 N3DPAircraft Holding Solutions LLC · Newark, DEBuilt 1981 · S/N 334 N400JXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 1602 N400MFDc-3 LLC · Juneau, AKBuilt 1944 · S/N 26877 N400UATatonduk Outfitters Ltd · Fairbanks, AKBuilt 1954 · S/N 44258 N401AVAircol 8 · Wilmington, DEBuilt 2009 · S/N 4001 N401JXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 1606 N401UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 435 N401USCorsair Two LLC · Hillsboro, ORBuilt 1957 · S/N 45145 N402UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 439 N403YKNorthern Air Cargo LLC · Anchorage, AKBuilt 1992 · S/N 25842 N404AAPacific Rim Management LLC · Downey, CABuilt 1982 · S/N 362 N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283 N404LCAirplane Sales International Corp · Sherman Oaks, CABuilt 1977 · S/N 4763 N404UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 450 N405CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1991 · S/N 25407 N405CPConocophillips Alaska Inc · Anchorage, AKBuilt 1990 · S/N 405 N405KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36132 N405LCLynden Air Cargo LLC · Anchorage, AKBuilt 1985 · S/N 5025 N405SVWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 1403 N405YKNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1991 · S/N 25267 N406AVBerry Aviation Inc · San Marcos, TXBuilt 1996 · S/N 460 N406CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1997 · S/N 28752 N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133 N406SVWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 1405 N406UAUnited Airlines Inc · Chicago, ILBuilt 1994 · S/N 454 N407LCLynden Air Cargo LLC · Anchorage, AKBuilt 1991 · S/N 5225 N407SVWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 1411 N408DAmerican Aerolux LLC · Sparta, TNBuilt 1940 · S/N 2247 N408LCLynden Air Cargo LLC · Anchorage, AKBuilt 1975 · S/N 4600 N409YKAircraft 25859 LLC · Lake Mary, FLBuilt 1993 · S/N 25859 N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284 N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353 N411AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4411 N411AVAircol 9 · Wilmington, DES/N 4011 N411SNAtares Funding LLC · Fisher Island, FLBuilt 1990 · S/N 48411 N412SNM48412 LLC · Estero, FLBuilt 1990 · S/N 48412 N413CMCargo Aircraft Management Inc · Wilmington, OHS/N 26988 N413WJN492a LLC · Goodyear, AZS/N 463 N413XJAviation Inventory Resources Inc · Alvarado, TXBuilt 1997 · S/N 340B413 N415JNAtares Funding LLC · Fisher Island, FLS/N 48415 N416AVAircol 19 · Wilmington, DEBuilt 2009 · S/N 4167 N416WMKen Sale Resource Inc · Southlake, TXS/N 487 N417XJBank Of Utah Trustee · Salt Lake City, UTS/N 340B417 N418LACernicalo Leasing LLC · Wilmington, DEBuilt 2005 · S/N 34246 N419AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26913 N419CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1997 · S/N 340B-419 N420LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 34627 N422AUPort Of Tillamook Bay · Tillamook, ORBuilt 1949 · S/N 15937 N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735

Back to AD 74-08-09 R2