OpenAirDocs.org
AD 97-05-03 R1

Registered aircraft · 2,860

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
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.

N453SMeanr LLC · Cleveland, OHBuilt 1982 · S/N 550-0445N4546VThwing Randy L · Las Vegas, NVBuilt 1948 · S/N D-1373N454DPSkyview LLC · Wilmington, DES/N 130N454MAMarv Air LLC · Chattanooga, TNBuilt 1998 · S/N 525-0286N455BYasky Richard J · Seaford, VABuilt 1948 · S/N D-1472N4560VCrane Russell S · Poplar Grove, ILBuilt 1948 · S/N D-1389N456BOr Meir Aviation · Youngstown, OHNon-citizen corporation, flight hours not reportedBuilt 1948 · S/N D-1473N456BEBillionaire Inc · St Petersburg, FLBuilt 1981 · S/N 335N456TX2141 Corp · Wilmington, DEBuilt 1980 · S/N 5500249N4578VMcpeck Adam S · Agar, SDS/N D-1244N4579VGcb Services LLC · Jacksonville, ORBuilt 1947 · S/N D-1221N457JCExceptional Aircrafts LLC · Mcallen, TXS/N 457N4584VHarrison Megan · Des Moines, IABuilt 1947 · S/N D-1052N458BSwensson Sean C · Alpine, CABuilt 1948 · S/N D-1475N458DACitation N458da LLC · Houston, TXS/N 560-0458N458NCBartmann Management LLC · Weatherford, OKBuilt 1998 · S/N 560-0478N4598VLandwell Pllc · Lake Havasu City, AZBuilt 1947 · S/N D-1151N459MBSt Pete Flight LLC · Saint Petersburg, FLS/N 5600438N459MDMosaic Leasing II LLC · Salem, ORBuilt 1991 · S/N 550-0685N459TJJohn R Lawson Rock & Oil Inc · Fresno, CABuilt 1981 · S/N 550-0308N45FSBristol Air LLC · Monte Vista, COS/N 5500562N45KNHawker800xp LLC · Dorado, PRBuilt 2003 · S/N 258635N45MLFarwest Aviation LLC · Billings, MTS/N 550-0367N45RCClassic Ag Aviation LLC · Kingston, OKBuilt 1990 · S/N 560-0071AN460RMMustang Two LLC · Newport Beach, CABuilt 2016 · S/N 525-0926N460SBIndigo Aviation LLC · Mcallen, TXBuilt 1991 · S/N 670N461ARSolo Energy Drink Inc · Miramar, FLS/N 384N462BJd Russell Co · Tucson, AZBuilt 1989 · S/N 560-0016N463AKFlying Farmer LLC · Wilmington, DEBuilt 1980 · S/N 162N4648LAquarius Investments LLC · Veguita, NMBuilt 2025 · S/N 525-1199N464BHPajarito Investments LLC · Salt Lake City, UTBuilt 2014 · S/N 525-0858N465JKDodeca Resources Inc · Henderson, NVBuilt 2017 · S/N 525-0949N466SGSao Enterprises LLC · Omaha, NEBuilt 1991 · S/N 550-0695N467AMBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 441N4687KNova Aviation LLC · Kemah, TXBuilt 2025 · S/N 525-1185N468BCassels William E · Phoenix, AZBuilt 1947 · S/N D-1120N469BBCentex Aero LLC Trustee · San Antonio, TXBuilt 1981 · S/N 434N469DEIndy Bravo LLC · Carmel, INBuilt 1999 · S/N 550-0883N469DNAerosam Equipment LLC · Beaver, PABuilt 1998 · S/N 560-0469N469ESRickman Joby · Lipan, TXBuilt 1995 · S/N 560-0311N46EWLexington Turbo LLC · Southborough, MABuilt 2013 · S/N 525-0802N46KKHuff Air LLC · Uvalde, TXBuilt 2018 · S/N 525-1013N46MFMed Flight Air Ambulance Inc · Albuquerque, NMBuilt 1981 · S/N 377N46MKSplendid Jet Lease LLC · Cape Coral, FLS/N 206N46WSCahoon Theodore J · Erie, COBuilt 1948 · S/N D-1253N470NANeptune Aviation Services Inc · Missoula, MTBuilt 1986 · S/N E2049N471MDCitation Management LLC · Pelham, ALBuilt 1995 · S/N 525-0122N472NANeptune Aviation Services Inc · Missoula, MTBuilt 1989 · S/N E2138N473DBTrans Air LLC · Helena, MTBuilt 1996 · S/N 525-0129N473NANeptune Aviation Services Inc · Missoula, MTBuilt 1985 · S/N E2045
Back to AD 97-05-03 R1