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.

N111WMMoore Forrest · Liberty Hill, TXBuilt 1978 · S/N 28R-7837159N1125TSpruce Tiger Aviation LLC · Dallas, TXBuilt 1976 · S/N 28R-7635448N1125XApm Leasing LLC · Casper, WYBuilt 1975 · S/N 28R-7535251N1126XBolobonoff Alexander G · Kingman, AZBuilt 1975 · S/N 28R-7535253N1128QZastrow Andrew S · Knoxville, TNBuilt 1977 · S/N 28R-7737027N112JRValleau Matthew J · Wallingford, CTBuilt 1973 · S/N 28R-7335341N112WSEdgeington Randall K · Riverton, WYBuilt 1961 · S/N 24-2765N1131QFarm Country Air LLC · Jefferson, IABuilt 1977 · S/N 28R-7703053N1134QFalyers Inc · Prairie Du Chien, WIS/N 32R-7780224N1138FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 28R35260N1138XPierce Nathaniel Antonio · Magnolia, DEBuilt 1975 · S/N 28R-7535256N113TRBell Thomas E · Henniker, NHBuilt 1976 · S/N 32R-7680207N113VKHaskell Brenton · Georgetown, KYBuilt 1978 · S/N 28R-7803352N113WYRyals Barry · Rhine, GABuilt 1974 · S/N 28R-7535055N1142XAerofeather Aviation Inc · Suffolk, VAS/N 34-7570221N1147N7371y LLC · Waterford, MIBuilt 1964 · S/N 30-423N1147HSpacious Skies LLC · Overland Park, KSBuilt 1977 · S/N 32R-7780139N1147XPax Flyers LLC · Hollywood, MDBuilt 1975 · S/N 28R-7535259N114CDNorwest Ventures LLC · Santa Cruz, CABuilt 1963 · S/N 30-37N114JRN114jr LLC · Canyon Lake, CABuilt 1975 · S/N 34-7570152N114RSLuggelle Michael · Hull, MABuilt 1966 · S/N 30-1094N114XTaft Plumbing Co Inc · Taft, CABuilt 1961 · S/N 24-2698N115DCLong Jerry D · Solvang, CABuilt 1973 · S/N 28R-7335405N1160XWagner Robert J · Dubuque, IABuilt 1975 · S/N 28R-7535261N1162XSeeding Operations And Atmospheric Reseach LLC · San Angelo, TXBuilt 1975 · S/N 34-7570225N1164XRegistered aircraftBuilt 1975 · S/N 28R-7535263N1166XEagle Aviation Inc · Tucson, AZBuilt 1975 · S/N 34-7570227N1168HKoplow Steve Alan · Sevierville, TNS/N 28R-7703015N116FRCloverfield Aero LLC · Los Angeles, CABuilt 2014 · S/N 2844150N1176XLyvers Joseph D · Louisville, KYBuilt 1975 · S/N 34-7570231N1177AN1177a LLC · Lewes, DEBuilt 1977 · S/N 32R-7780430N1179XDesch Edward J III · Aldie, VABuilt 1975 · S/N 28R-7535267N117MBLittmarck Svante · Dedham, MABuilt 2014 · S/N 2844151N117SCJenkins Matthew A · Bend, ORS/N 28R-7703343N117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CABuilt 1968 · S/N 28R-30443N1188XSteven H Baker Construction Co · Big Bear City, CABuilt 1975 · S/N 28R-7535274N1188YSkylark Flight Training LLC · Panama City, FLBuilt 1964 · S/N 30-403N118BLEdge Aviation LLC · Hawthorne, FLBuilt 1965 · S/N 30-913N118ESCmv Aviation LLC · Johnson City, NYBuilt 1976 · S/N 32R-7680374N1194HCrnic Paul C · Chesterfield, MOS/N 28R-7703016N1194XCantrell William Terry · Spring Hill, TNS/N 34-7570236N1198HAlge Aviation · Middletown, DES/N 32R-7780143N119EAce Aeromotive Inc · Miami, FLBuilt 1958 · S/N 24-532N11CGComanche 260b-N11cg · Pomeroy, WABuilt 1966 · S/N 24-4434N11CVStoots Christa M · Tucson, AZS/N 24-4130N11CWJabez Aviation LLC · Petaluma, CABuilt 1977 · S/N 28R7737079N11FLBell Christopher K · Ashley, OHBuilt 1968 · S/N 28R-30444N11HRHf Aero LLC · Lusby, MDBuilt 1979 · S/N 34-7970233N11JUPottorff Gregory K · Wayne City, ILBuilt 1973 · S/N 28R-7335374N11KYKlad-Air LLC · Catlett, VABuilt 1966 · S/N 30-1181
Back to AD 97-01-01 R1