OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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

N2740RRegistration Pending · Wilmington, DERegistration pendingS/N 28R-35280N2742RCollinsworth Frederick W · Broken Arrow, OKBuilt 1969 · S/N 28R-35281N2744MCas Aviation LLC · Warwick, RIBuilt 1977 · S/N 28R-7803142N2746QArrow Three LLC · Orlando, FLS/N 28R-7703075N2751MWktr Inc · Cocoa Beach, FLBuilt 1977 · S/N 34-7870092N2758QDayton Stephen · Littleton, NHBuilt 1977 · S/N 32R-7780264N2759RFord William(Bill) A III · Abilene, TXBuilt 1969 · S/N 28R-35284N276DBN276db LLC · Mesa, AZBuilt 1976 · S/N 34-7670238N276JSEagle Flight Academy LLC · Owensboro, KYBuilt 1964 · S/N 30-422N276MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2844180N2770RHayward Flight LLC · Hayward, CABuilt 1969 · S/N 28R-35287N2779MFuist Richard · Lake City, FLS/N 28R-7803145N277AMParis Air Inc · Vero Beach, FLBuilt 1974 · S/N 34-7450188N277DDWicked Flyby LLC · Lewes, DEBuilt 1960 · S/N 24-1818N2781RBurley Robert L · Alliance, OHBuilt 1969 · S/N 28R-35272N2782YDegroff Steven A · Berne, INBuilt 1964 · S/N 26-59N2784QMaulhardt Lynn Edward · Oxnard, CAS/N 28R-7703077N278NDRegistered aircraftBuilt 2002 · S/N 2844069N2793QN2793q LLC · Westerville, OHS/N 32R-7780265N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034N27BRLarson Allen L · Capron, ILBuilt 1969 · S/N 24-4909N27GSMazzola Michael · Baton Rouge, LABuilt 1977 · S/N 28R-7737160N27PCRegistration Pending · Houston, TXRegistration pending, pending cancellationBuilt 1962 · S/N 24-3022N27WMHeidebrink Ronald E · West Chester, OHS/N 28R7703197N2801RSummers Clinton D · Maysville, NCBuilt 1969 · S/N 28R-35288N2802TRandolph Clint · Bullhead City, AZBuilt 1972 · S/N 28R-7235134N2807RHayzan Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28R-35294N280ASBravo Aviation Club LLC · Cary, NCBuilt 1977 · S/N 32R7780155N280DABouffard Marcel · Flowery Branch, GABuilt 1977 · S/N 28R-7737154N280NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844014N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101N2811RLantz Raymond J · Huntington Beach, CABuilt 1969 · S/N 28R-35296N2815MEd Hamilton Investments Lc · Richmond, TXBuilt 1977 · S/N 28R-7803147N2816RBipes Anthony G · Forest Lake, MNS/N 28R-35297N2817RHunt Loren M · Nevada, MOBuilt 1969 · S/N 28R-35298N281NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844015N2823TAircraft Restoration LLC · Valparaiso, INBuilt 1972 · S/N 28R-7235140N2824TEscudier Henry · Houston, TXBuilt 1972 · S/N 34-7250171N2825TBeatty Daniel H · Bronx, NYS/N 28R-7235122N2826TKochersberger Kevin B · Blacksburg, VABuilt 1972 · S/N 28R-7235016N2827NN714dd LLC · Pembroke Pines, FLBuilt 1979 · S/N 34-7970262N2828LInverted LLC · Las Vegas, NVS/N 34-7970266N282NDMoore Aviation Inc · Beaver Falls, PABuilt 2000 · S/N 2844024N282PGitlow Stuart · Woonsocket, RIBuilt 1964 · S/N 30-508N2831TMesiemore Roger · Lake Wylie, SCBuilt 1972 · S/N 28R-7235141N2832TKirtland Air Force Base Aero Club · Kirtland Afb, NMBuilt 1972 · S/N 28R-7235142N283PAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2001 · S/N 2844059N2841RMoses Aviation Services LLC · Uvalde, TXBuilt 1969 · S/N 28R-35305N2844ML C C West LLC · Freehold, NJBuilt 1977 · S/N 28R-7837102
Back to AD 97-01-01 R1