OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,915

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.

N338672 F LLC · Valentine, NEBuilt 1975 · S/N 28R-7535209N338PAFl Ventures I LLC · Winter Park, FLBuilt 2002 · S/N 2844076N3397QMills Ronald S · South Jordan, UTBuilt 1977 · S/N 28R-7703106N339DALink Aviation LLC · Eau Claire, WIBuilt 2002 · S/N 2844077N33DNRegistered aircraftBuilt 1969 · S/N 24-4896N33EGHoug David M · Pigeon Forge, TNFirst renewal noticeS/N 28R-7803031N33ESDuncan Ernest Michael · Dripping Springs, TXBuilt 1976 · S/N 28R-7635461N33JFKimsey Thomas Wayne · Warner Robins, GABuilt 1965 · S/N 30-820N33JRMil2atp Inc · Pikeville, NCBuilt 1975 · S/N 34-7570113N33MQN33mq LLC · Perrysburg, OHBuilt 1976 · S/N 34-7770027N33PHPine Creek Adventures Inc · Benton, PABuilt 1959 · S/N 24-1451N33PRWings To Carolina LLC · State College, PABuilt 1976 · S/N 32R-7780087N33SSRegistration Pending · Palmdale, CARegistration pendingBuilt 1966 · S/N 30-1104N33TGPiper LLC · Crystal Lake, ILBuilt 1975 · S/N 28R-7635006N33WJKite Air LLC · Staten Island, NYBuilt 1977 · S/N 32R-7780443N33ZMUrban Timothy J · Laytonsville, MDBuilt 1966 · S/N 30-1044N3405MSpectrum Exploration LLC · Jacksonville, TXBuilt 1977 · S/N 28R-7803169N341TCRegistration Pending · Wilmington, DERegistration pendingBuilt 1974 · S/N 34-7450161N34201Talon Air LLC · Newport, KYS/N 34-7450185N3420QBalladares Charles V · Mandeville, LABuilt 1977 · S/N 28R-7737054N3423QTrebs Adam · Tucson, AZBuilt 1977 · S/N 28R-7703108N342GRSouthern Aero LLC · Homestead, FLBuilt 1972 · S/N 34-7250021N3433QGhamari Seyavosh · Irvine, CAS/N 28R-7703109N343SArrow 180 LLC · Reno, NVBuilt 1969 · S/N 28R-31118N343WPPapa LLC · Eufaula, ALBuilt 1978 · S/N 28R-7837136N3449MCarhart Thomas M · Galesville, WIBuilt 1977 · S/N 28R-7837114N344ACInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28R-7803350N344MCEuroaviation Inc · KematenBuilt 1973 · S/N 34-7450008N344TBScifers John W · Sarasota, FLS/N 34-7770181N344TXCline Lyndi · Royce City, TXBuilt 1966 · S/N 24-4478N345ACManagement Co LLC · West Columbia, SCBuilt 1977 · S/N 34-7870087N345CDP&N Corp · Marion, IAS/N 34-7770148N345HPMarek Gary A · Lemont, ILBuilt 1961 · S/N 24-2508N3464QMac Air Inc · Farmington, MOS/N 28R-7703110N3467QHawthorne Mark · Flagstaff, AZS/N 28R-7703111N346RMHansen Alexander G · Glendale, CABuilt 1958 · S/N 24-929N347CBMishock Kevin A · Melbourne, FLBuilt 1976 · S/N 32R-7780002N3488MStrand Laird W · Appleton, WIBuilt 1978 · S/N 28R-7803173N349SBSkyfusion II LLC · Atlanta, GABuilt 1977 · S/N 32R-7780480N34BFSam Aviation LLC · Elberton, GABuilt 1975 · S/N 34-7670029N34EECodingflyboy LLC · Hayward, CABuilt 1966 · S/N 30-1138N34ESTough Old Bird Aviation LLC · Beavercreek, OHBuilt 1973 · S/N 34-7450078N34LMNorfolknway LLC · Mount Pleasant, SCS/N 34-7770133N34MYParis Air Inc · Vero Beach, FLS/N 34-7450088N34PTJentone Aviation LLC · Aber Prov Grd, MDBuilt 1974 · S/N 28R-7535029N34RABurke William G III · Fayetteville, GABuilt 1964 · S/N 30-342N3511TTippett Daniel W · Heath, OHBuilt 1973 · S/N 28R-7435063N3514MCooley David Alan · Harrod, OHBuilt 1978 · S/N 28R-7803175N3522Barnett Charles J · St Peter JerseyBuilt 1969 · S/N 30-1787N353SBurdick Steven David · Saint Paul, MNBuilt 1968 · S/N 28R-30851
Back to AD 97-01-01 R1