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.

N7139PPendlay Heath V · Kalispell, MTS/N 24-2304N713JRO Reilly Robert · Houston, TXBuilt 1961 · S/N 24-2233N7141PWild Aire LLC · Wilmington, DEBuilt 1960 · S/N 24-2306N7142PCorbets Jeffrey B · Santa Clarita, CABuilt 1960 · S/N 24-2307N7143PKc Flyers Inc · Wilmington, DEBuilt 1960 · S/N 24-2308N7144PAllis Frederick M · Eden Prairie, MNBuilt 1960 · S/N 24-2309N7145PAstraeus Lc · Evanston, WYBuilt 1960 · S/N 24-2310N7146PRichardson Eeseh A G · Loganville, GABuilt 1960 · S/N 24-2311N7147YLee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYBuilt 1963 · S/N 30-164N7150PPickerill Robert L · Hopkinsville, KYBuilt 1960 · S/N 24-2315N7153PKnutson Daniel T · Lodi, WIBuilt 1960 · S/N 24-2318N7154PPearson Matthew · Rohnert Park, CABuilt 1977 · S/N 32R-7780462N7155YSheasley George · Eagle Creek, ORFirst renewal noticeBuilt 1963 · S/N 30-173N7156PWeinzapfel Joe M · Muenster, TXBuilt 1960 · S/N 24-2322N7157YTailwind Consulting LLC · Port Orange, FLS/N 30-175N7159PAdams George D · Franklin, INFirst renewal noticeBuilt 1960 · S/N 24-2325N7159YPepmiller Scott C · Panama City Beach, FLS/N 30-177N715BDBlack Thomas D · Clearwater, FLBuilt 1976 · S/N 34-7670133N7161PMaurer Bruce C · Power, MTBuilt 1960 · S/N 24-2327N7162CWyoming Valley Air LLC · Old Forge, PABuilt 1975 · S/N 34-7570301N7163YBoyd John W · Milton, WABuilt 1963 · S/N 30-184N7164YGreat Lakes Air Ventures LLC · Mason, MIBuilt 1963 · S/N 30-185N7166YCollum Aviation LLC · Milton, FLBuilt 1963 · S/N 30-187N7167YThomas Thomas J · Lewisburg, WVBuilt 1963 · S/N 30-188N7168PSchober Brian S · Scottsdale, AZBuilt 1960 · S/N 24-2336N7170PDalton Dennis P · Walsenburg, COBuilt 1960 · S/N 24-2338N7171YHeinrich Steven W · Conroe, TXBuilt 1963 · S/N 30-191N7172PBarksdale Kevin L · Moore, OKBuilt 1960 · S/N 24-2340N7175PNewton Roger N Jr · Marerro, LABuilt 1960 · S/N 24-2344N7177POverstreet Robert S · Clarksville, VABuilt 1964 · S/N 24-3635N7178PN9271p LLC · Pahrump, NVBuilt 1960 · S/N 24-2347N7179PHedgpeth H Brent · Bothell, WABuilt 1960 · S/N 24-2348N717RTAndreini Linda J Trustee · Half Moon Bay, CAS/N 34-7670221N717TATwin C Aviation Inc · Chapel Hill, NCBuilt 1966 · S/N 30-1030N7180P352 Aviation LLC · Clermont, FLBuilt 1960 · S/N 24-2349N7180YAl-Banna Emad R · Huntingtown, MDBuilt 1963 · S/N 30-200N7181PStrydom Cornelis F · Liberal, KSS/N 24-2350N7182YMccue John M · Tuttle, OKS/N 30-206N7183KRabourn John P · Spokane, WABuilt 1963 · S/N 30-207N7184PWilson Brian E · Lecanto, FLBuilt 1960 · S/N 24-2354N7185PMack Darryl T · Matteson, ILBuilt 1960 · S/N 24-2355N7186YHill Mark T · Gloucester, VAS/N 30-210N7187YAircore LLC · Apache Junction, AZBuilt 1963 · S/N 30-211N7188PBackcourse Flyers Inc · Powell, TNS/N 24-2358N7188YRegistration Pending · Christiansted, VIRegistration pendingBuilt 1963 · S/N 30-212N7189PTofan Ray · National City, CABuilt 1960 · S/N 24-2359N7189YHesano Joseph M · Rockford, ILBuilt 1963 · S/N 30-213N718JRFlytwincos LLC · Las Vegas, NVBuilt 1964 · S/N 30-276N7190YMiller Kevin · Collegedale, TNBuilt 1963 · S/N 30-214N7191PRamineni Raja · Fort Mill, SCBuilt 1961 · S/N 24-2361
Back to AD 97-01-01 R1