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.

N7676YCoffman Robert P · Bigfork, MTBuilt 1964 · S/N 30-755N7677PHenderson William C · Grafton, WVBuilt 1961 · S/N 24-2888N7678PMunday Jeff R · Waverly, GAS/N 24-2889N767KPPhill-Air Inc · Dover, DEBuilt 1966 · S/N 30-1193N767PEDaytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350042N7681FLowrance Kenneth D · Saint Louis, MOBuilt 1976 · S/N 34-7770066N7681YTaft Aviation LLC · Brookhaven, NYBuilt 1965 · S/N 30-759N7682JAv Serv LLC · Dover, DEBuilt 1969 · S/N 28R-31083N7683PCavel Lonnie R · Vidor, TXBuilt 1961 · S/N 24-2892N7684CDecastro Edward A · Laramie, WYBuilt 1976 · S/N 34-7570260N7684PPache Keith M · Montgomery, TXBuilt 1961 · S/N 24-2893N7685PPinkel Lawrence W · Albuquerque, NMBuilt 1961 · S/N 24-2894N7685YNehrbass Douglas J · Clarksville, TNBuilt 1965 · S/N 30-765N7686JCovic Craig A · Cordova, TNBuilt 1969 · S/N 28R-31087N7686YMontana Leasing Group LLC · Park City, UTBuilt 1965 · S/N 30-766N7688JClapp Rollyn D · Volga, SDBuilt 1969 · S/N 28R-31266N7689YGitlow Stuart · Woonsocket, RIBuilt 1965 · S/N 30-769N7690JFox Two LLC · Camino, CABuilt 1969 · S/N 28R-31071N7692FCwh Properties LLC · Falls City, NES/N 32R-7780080N7692JFlying Wings Of Louisiana · Denham Springs, LAS/N 28R-31092N7692PKelly Joseph · Austin, TXFirst renewal noticeBuilt 1961 · S/N 24-2902N7692YAloof Aviation LLC · Denver, COBuilt 1965 · S/N 30-774N7693PCrane James M · Clayton, NCBuilt 1961 · S/N 24-2903N7693YSkywalker Flight School LLC · Adrian, MIBuilt 1965 · S/N 30-775N7694PN7694p Enterprises Inc · Dover, DEBuilt 1961 · S/N 24-2904N7695YGriffith David B · Gilmer, TXBuilt 1965 · S/N 30-777N7696PJones Clayton S · Kalispell, MTBuilt 1961 · S/N 24-2907N7697PMascheck Anthony Q · Harker Heights, TXBuilt 1961 · S/N 24-2908N7697YRegistration Pending · Rosamond, CARegistration pending, canceledBuilt 1965 · S/N 30-780N7698C98charlie LLC · Van Wert, OHBuilt 1975 · S/N 32R-7680059N7698JMetz Mark A · Ida, MIBuilt 1969 · S/N 28R-31098N7698PJohn Tom · Las Vegas, NVBuilt 1961 · S/N 24-2909N7699JHamilton John B · Stafford, VABuilt 1969 · S/N 28R-31099N769GSSkylar Aviation LLC · Hagerhill, KYBuilt 1977 · S/N 32R-7780236N769JHorn Warren B · Athens, GAS/N 28R-7335147N769TTBrawndair Geminus LLC · Chesapeake, VABuilt 1975 · S/N 34-7570012N76EHMitchell Matthew J · Penn Yan, NYBuilt 1975 · S/N 32R-7680034N76FR76 Freedom LLC · Greenville, INBuilt 1977 · S/N 32R-7780317N76PBPlastic Bottle Corporation · Libertyville, ILBuilt 1978 · S/N 34-7970067N76WCGolf Aero Corp · Arlington, TXBuilt 1975 · S/N 34-7670053N7700PBarber Chris · Toney, ALBuilt 1961 · S/N 24-2911N7703YNixon Christopher M · Washington, INBuilt 1965 · S/N 30-789N7704PDolin Irving M · Gardner, KSBuilt 1961 · S/N 24-2916N7706YHighway Whisperer LLC · Wilmington, DES/N 30-794N7707PSweitzer Cameron D · Warrensburg, MOBuilt 1961 · S/N 24-2919N7707YLoveless John R Trustee · Bynum, TXBuilt 1965 · S/N 30-712N7709YBauer Aviation LLC · Reese, MIBuilt 1965 · S/N 30-797N7711Thomas Conrad H K · Lake City, FLS/N 24-3397N7711PWhitewater Aviation Inc · Harrison, OHBuilt 1961 · S/N 24-2924N7712FRice Robert Dalton · Kerrville, TXBuilt 1976 · S/N 32R-7780082
Back to AD 97-01-01 R1