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.

N7765YAce Vne LLC · Stevensville, MIBuilt 1965 · S/N 30-852N7767PStock Keith A · Warrensburg, MOS/N 24-2983N7768PGreensburg Jeannette Airport Administration Inc · Jeannette, PAS/N 24-2984N776CHHassler William J · Houston, TXBuilt 1965 · S/N 30-753N7770DJenkins Robert H · Kill Devil Hills, NCBuilt 1972 · S/N 28R-7235220N7770LEiler Donald L · Des Moines, WABuilt 1974 · S/N 34-7570046N7770PGlau Jon E · Englewood, COBuilt 1961 · S/N 24-2986N7771YDakota Executive Flight Inc · Miller, SDBuilt 1965 · S/N 30-857N7773PJenkins John R · Fairmont, WVBuilt 1962 · S/N 24-2989N7773YBismuth Robert · Seattle, WABuilt 1965 · S/N 30-859N7774YReed John · Seattle, WABuilt 1965 · S/N 30-860N7776PHardin Gerald A · Port Clinton, OHFirst renewal noticeBuilt 1962 · S/N 24-2993N7777PWeihe Philip D · Cleveland Heights, OHBuilt 1961 · S/N 24-2994N7777YDigati Anthony J · Mentone, CAS/N 30-863N7778YSpiegel Eitan · San Francisco, CABuilt 1965 · S/N 30-864N7779YMccool Kenneth W · Olive Branch, MSBuilt 1965 · S/N 30-865N777BBMrnak Andy M · Bowman, NDBuilt 1961 · S/N 24-2227N777CD777cd LLC · Rochester, MNBuilt 1978 · S/N 28R-7803255N777DFOl Hughes LLC · Staplehurst, NEBuilt 1972 · S/N 24-5019N777EEDga Aviation LLC · Sacramento, CABuilt 1961 · S/N 24-2773N777FSCasey William F · Ponderay, IDBuilt 1972 · S/N 39-121N777JDFwm Aviation Inc · Washington, DCBuilt 1977 · S/N 28R-7703156N777JRMiloud Chadd K · Fort Worth, TXBuilt 1972 · S/N 34-7350093N777KGLonnevik Dennis F · Bigfork, MTBuilt 1966 · S/N 30-1159N777KPKelly'S Flying Service LLC · Warrensburg, MOBuilt 1963 · S/N 30-110N777MURobinson James G · Baltimore, MDBuilt 1964 · S/N 26-83N777RHLarson Peter T Trustee · Coraopolis, PABuilt 1965 · S/N 30-908N777SKDj Internet Commerce LLC · Crowley, LABuilt 1977 · S/N 32R-7780017N777WLucky Shot LLC · Dayton, OHBuilt 1977 · S/N 32R-7780297N777ZZMiller Jordan Raul · Columbus, OHFirst renewal noticeS/N 24-1495N7780PMolinari Eugene A Jr · Milton, FLBuilt 1961 · S/N 24-2997N7781PBallard William S · Sanford, NCBuilt 1962 · S/N 24-2998N7786POlson Arthur W · Fairbanks, AKBuilt 1962 · S/N 24-3003N7786YBell Frank · Tuxedo, NCBuilt 1965 · S/N 30-869N7787YBucks Flight Academy LLC · Cashion, OKBuilt 1965 · S/N 30-870N7788PEight Eight Papa Inc · Williamsport, PABuilt 1962 · S/N 24-3005N7790YMaki Stephen B · New Port Richey, FLBuilt 1965 · S/N 30-146N7791YMaki Stephen B · New Port Richey, FLBuilt 1965 · S/N 30-874N7792PAdkins Brian Keith · Twp Washinton, NJBuilt 1962 · S/N 24-3009N7793YRedinger Aaron · Hanlontown, IABuilt 1965 · S/N 30-876N7794PWard Ronald Kevin · Santa Rosa, CAS/N 24-3011N7795PBressman John W · Belton, MOBuilt 1962 · S/N 24-3012N7796PDsr Cherokee 180 LLC · Dallas, TXBuilt 1962 · S/N 24-3014N7797PGrassi Michael A · Waterford, MIBuilt 1963 · S/N 24-3015N779AKJust Plane Partners LLC · Yorba Linda, CABuilt 1974 · S/N 28R-7435160N77AHPate Steven H · El Paso, TXBuilt 1977 · S/N 28R-7703223N77AJGreen Nicholas S · Lakeland, TNBuilt 1976 · S/N 32R-7680371N77CHTcb Management Inc · Chiefland, FLBuilt 1971 · S/N 39-136N77LZO'Quinn Debbie M · Jesup, GAS/N 28R-7737073N77PMSokrispymedia LLC · Greenville, SCS/N 28R-7703030
Back to AD 97-01-01 R1