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.

N15289Story Aranzazu · Draper, UTBuilt 1972 · S/N 28R-7335046N1530XQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 28R-7535312N15313Beine Gilbert J · Campbellsport, WIBuilt 1972 · S/N 28R-7335049N15324Lewis Christopher Dean · Bettendorf, IABuilt 1972 · S/N 28R-7335050N1532XRaymond Darwin V · Glenwood Springs, COBuilt 1975 · S/N 34-7570275N15334Shuart Bruce E · Wantage, NJBuilt 1972 · S/N 28R-7335051N1533EPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7350050N1536XClark Christopher · Ormond Beach, FLBuilt 1975 · S/N 34-7570276N15379Huyler John C · Shreveport, LABuilt 1972 · S/N 28R-7335053N15380Miller Aviation Group LLC · Coon Rapids, MNBuilt 1972 · S/N 28R-7335054N1538XStaton Justin · Kemah, TXBuilt 1975 · S/N 28R-7535315N153ASBowen Arrow Aviation Inc · Albany, NYBuilt 1976 · S/N 28R-7635436N15473Cerniglio Dominic Antonio · Sebastopol, CAS/N 28R-7335061N1547XKoch Steven T II · Brownsburg, INBuilt 1975 · S/N 28R-7535321N154BJDent Air Ltd · Annapolis, MDBuilt 1977 · S/N 32R-7780251N1550XVictors Vectors LLC · Valparaiso, INS/N 28R-7535323N1551XLeverson Christopher · Austin, TXBuilt 1975 · S/N 34-7570283N15523Derryberry Clay · Lewisburg, TNBuilt 1972 · S/N 28R-7335065N15524Brown Gerald · Apple Valley, MNBuilt 1972 · S/N 28R-7335066N15529Pattie Donald D · Zephyrhills, FLBuilt 1972 · S/N 34-7350072N1553XGreat Divide Aircraft LLC · Louisville, COBuilt 1975 · S/N 32R-7680003N15545Ungaro James P Sr · Las Vegas, NVBuilt 1972 · S/N 28R-7335068N1554XBertagna LLC · Chico, CABuilt 1975 · S/N 28R-7535324N1555MReed Calvin H · Tampa, FLS/N 28R-7703146N1555XShelton Brad · Wildwood, MOBuilt 1975 · S/N 34-7570284N15562Hulihan Tom · Eerie, COBuilt 1972 · S/N 28R-7335070N15589Neal Alan B · Cherry Valley, CABuilt 1972 · S/N 34-7350078N15597Watson Keith A · Sale Creek, TNBuilt 1972 · S/N 28R-7335072N15600Curry Dwain · Apopka, FLBuilt 1972 · S/N 28R-7335073N15623Terrill Wallace · Otis, MABuilt 1972 · S/N 28R-7335075N1562XLaliberte Christopher M · Ridgecrest, CABuilt 1975 · S/N 28R-7535326N15633Jime Aero LLC · Ontario, CABuilt 1972 · S/N 28R-7335076N15643Aerolease Ltd · Dubuque, IABuilt 1972 · S/N 28R-7335088N15644Meriden Aviation Center LLC · Meriden, CTBuilt 1972 · S/N 28R-7335077N15647Flynn Daniel C · Malvern, PAS/N 34-7350082N15665Burns Dana W · Pataskala, OHS/N 28R-7335079N15684Carr Sean Michael-Noel · Prescott, AZBuilt 1972 · S/N 28R-7335081N1569XStroud Jerry L · Hope, ARS/N 28R-7535331N156DCEaton Billy J · Bridgeport, TXBuilt 1961 · S/N 24-2751N156LMLoup Technologies Inc · Longmont, COBuilt 1966 · S/N 30-1017N15709Avioelectronica Inc · Sunrise, FLS/N 34-7350088N1570XTmstarservices LLC · Lewes, DEBuilt 1975 · S/N 34-7570290N15744West Kentucky Flyers Corp · Murray, KYBuilt 1972 · S/N 28R-7335086N1574XQuinones Roland · Plano, TXS/N 28R-7535338N15764Leyva Jose Luis · New Smyrna Beach, FLBuilt 1972 · S/N 28R-7335089N15765Moulder Tyler Dane · Huntsville, ALBuilt 1972 · S/N 28R-7335090N15789Sidc2 LLC · North East, MDBuilt 1973 · S/N 34-7350094N157BJHolm Brian · Buckley, WABuilt 1975 · S/N 34-7570282N157CMChamark LLC · Knoxville, TNBuilt 1975 · S/N 32R-7680023N15814Alderson Collin · North Bend, NEBuilt 1972 · S/N 28R-7335094
Back to AD 97-01-01 R1