Skip to content

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.

N3172Bank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 340B172 N317AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-317 N317AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25445 N317CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24317 N317PGAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33344 N318FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 28318 N319CMCargo Aircraft Management Inc · Wilmington, OHS/N 24407 N319USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 208 N320AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-320 N320MKAdaka-Sb LLC · Orlando, FLBuilt 1982 · S/N 370 N321CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29431 N321USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 262 N322SGAtlas Air Inc · Purchase, NYBuilt 2000 · S/N 30322 N3239TValiant Air Command Inc · Titusville, FLBuilt 1987 · S/N 19054 N323AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-323 N323CMBank Of Utah Trustee · Salt Lake City, UTS/N 29881 N323WWWin Win Aviation Inc · Wake Forest, NCBuilt 1978 · S/N SH3026 N324JWVip Jet Transportation Inc · Bishop, CABuilt 1981 · S/N 324 N325FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28325 N325USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 281 N326FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28326 N326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIS/N 20917 N327AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 340B-427 N328NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 298 N3291International Air Services Inc Trustee · Carson City, NVBuilt 1940 · S/N 2204 N329AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-329 N329NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 306 N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914 N32MJAviation Company Inc · Cheyenne, WYBuilt 1982 · S/N 460 N3300CCsds Asset Management LLC · Marana, AZS/N 211 N330ADBank Of Utah Trustee · Salt Lake City, UTS/N 330 N330AEBank Of Utah Trustee · Salt Lake City, UTS/N 33007 N330ENUniversal Hydrogen Co · Hawthorne, CABuilt 1991 · S/N 274 N33103Umb Bank Na Trustee · Salt Lake City, UTBuilt 1994 · S/N 27293 N33132United Airlines Inc · Chicago, ILBuilt 1998 · S/N 29281 N331AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 24875 N331CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1986 · S/N 23747 N331TBMassachusetts Institute Of Technology · Lexington, MABuilt 1992 · S/N 340B-331 N33203United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30613 N33209United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30581 N33262United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32402 N33264United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31584 N33266United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32403 N33284Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31635 N33286United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31600 N33289United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31607 N33292United Airlines Inc · Chicago, ILBuilt 2004 · S/N 33455 N33294Wells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2005 · S/N 34000 N332AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-332 N332CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1987 · S/N 23707

Back to AD 74-08-09 R2