Registered aircraft · 2,862

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

N540EALastra Air Cargo Express · Saint Petersburg, FLS/N 174 N540JLBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 525-1138 N540KTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2005 · S/N 258702 N540PAPhoenix Air Group Inc · Cartersville, GABuilt 1977 · S/N 101 N540WCFirst State Bancshares Inc · Farmington, MOBuilt 2025 · S/N 525-1187 N541XPJoveros Aviation LLC · Miami, FLBuilt 2001 · S/N 258541 N542GHHepner G L · New Port Richey, FLBuilt 1947 · S/N D-1067 N542LMAero Air LLC · Hillsboro, ORBuilt 1980 · S/N 35A-280 N543LMMarklyn Jet Parts LLC · Dallas, TXBuilt 1981 · S/N 426 N544CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 550-0701 N544LMCorsair Two LLC · Hillsboro, ORBuilt 1983 · S/N 500 N544PAPhoenix Air Group Inc · Cartersville, GABuilt 1979 · S/N 247 N544PSLucas Aviation LLC · Fremont, MIBuilt 2000 · S/N 258491 N545JSSuperus Capital Partners LLC · Memphis, TNBuilt 2003 · S/N 525-0524 N545LSBlue Earth Cellular LLC · Blue Earth, MNBuilt 2014 · S/N 525-0840 N545RWNegative Contact LLC · Albuquerque, NMBuilt 1996 · S/N 525-0141 N545TGStarr Mountain Aviation LLC · Athens, TNBuilt 2004 · S/N 525-0545 N546CGCoulson Aviation USA Inc · Portland, ORBuilt 1991 · S/N 5500686 N547CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1991 · S/N 550-0687 N548CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 550-0700 N549BWhite Judy C · Fall City, WABuilt 1948 · S/N D-1479 N549CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 5500699 N549PACff Air Inc · Wilmington, DEBuilt 1977 · S/N 119 N54CYExtollo Aviation Partners LLC · Denver, COBuilt 2017 · S/N 525-0953 N54DAThoroughbred II LLC · State College, PABuilt 2001 · S/N 525-0470 N54DDChrysler Aviation Inc · Van Nuys, CABuilt 1990 · S/N 5600089 N54DRGarcia David D · Midlothian, TXS/N 94 N54HCThree Bears Aviation LLC · Prineville, ORBuilt 1996 · S/N 525-0157 N54HTBravo V Aviation LLC · Harrisburg, PABuilt 2001 · S/N 550-1001 N54MZFinch John Lambeth · Greensboro, NCBuilt 2023 · S/N 525-1154 N54TPTsc N94pl LLC · Wichita Falls, TXS/N 5600160 N54YPPhifer Inc · Tuscaloosa, ALBuilt 2003 · S/N 333 N550ABAbt Aviation LLC · Bay City, MIBuilt 1990 · S/N 550-0633 N550AS550 LLC · Kalispell, MTBuilt 1981 · S/N 550-0390 N550BCCb Air LLC · Fayetteville, ARS/N 550-0804 N550BJLybl Air 2 LLC · Portland, ORBuilt 2002 · S/N 550-1029 N550BMMareth Management Inc · Monett, MOBuilt 1979 · S/N 550-0117 N550CFMidwest Jet LLC · Marshall, MNBuilt 1991 · S/N 550-0669 N550CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 550-0677 N550CTGroup Two LLC · North Dinwiddie, VABuilt 1978 · S/N 5500033 N550DCM A / F H Aviation Inc · Dayton, OHBuilt 1992 · S/N 560-0198 N550FPJk Aircraft Options LLC · Aripeka, FLBuilt 1983 · S/N 550-0468 N550GZFlybynight LLC · Imperial, CABuilt 1979 · S/N 5500092 N550HHGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1997 · S/N 550-0802 N550HJBravo II LLC · Carmel, INS/N 550-1117 N550HKGlass City Leasing LLC · Perrysburg, OHS/N 550-0816 N550JMayes John · Carson City, NVBuilt 1998 · S/N 550-0848 N550JFTs Aviation LLC · New York, NYBuilt 1985 · S/N 472 N550JXN918vc Corp · Wilmington, DEBuilt 1987 · S/N 550-0557 N550MJMidwest Jet LLC · Lynd, MNBuilt 1981 · S/N 550-0215

Back to AD 97-05-03 R1