OpenAirDocs.org
AD 97-05-03 R1

Registered aircraft · 2,861

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-05-03-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-05-03-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.

N190JKAnswers Collective Inc · Hamilton, OHBuilt 1995 · S/N 560-0303N190KRegistered aircraftBuilt 1994 · S/N 560-0279N190MCN560mc LLC · Raleigh, NCBuilt 2007 · S/N 560-0769N190PASandy Wings LLC · Wilmington, DES/N 320N1910AKms Air LLC · West Bend, WIBuilt 2005 · S/N 258711N191NMcm Leasing LLC · Pittsfield, MABuilt 2003 · S/N 334N191TFCci Air LLC · Gary, INBuilt 1988 · S/N 550-0567N191VFN191vf LLC · Birmingham, ALBuilt 2002 · S/N 560-0627N193PCSomewhre 193 Pc LLC · Keene, TXS/N 550-1081N193SETitan Aviation LLC · Wilmington, DES/N 560-0229N193SGSunshine Sky Aviation LLC · Doral, FLBuilt 2003 · S/N 258627N194MGSdw Aviation LLC · Albany, GABuilt 1999 · S/N 525-0357N194SAPennair LLC · Katy, TXBuilt 1993 · S/N 560-0238N1953KKms Air LLC · West Bend, WIBuilt 2006 · S/N 258775N1957NAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2024 · S/N 525-1182N195MFHat*Trick Holdings LLC · Buchanan, MIBuilt 1995 · S/N 525-0110N195PASandy Wings LLC · Wilmington, DEBuilt 1983 · S/N 399N1967GGary Ventures Inc · Denver, COBuilt 2003 · S/N 5600641N1969JRegistered aircraftBuilt 1994 · S/N 560-0277N196PASandy Wings LLC · Wilmington, DES/N 321N197MJSkyview LLC · Wilmington, DES/N 197N197PRGoodnights Spruce Goose LLC · Harmony, NCBuilt 1992 · S/N 550-0704N1989BN455jw LLC · Missoula, MTBuilt 1988 · S/N 217N198PABartowjets LLC · Wilmington, DEBuilt 1986 · S/N 482N19DPMonterey Bay LLC · Atlanta, GABuilt 1993 · S/N 525-0040N19HUStoneway Aviation LLC · Prospect, KYBuilt 1991 · S/N 560-0135N19RCTequila Flights LLC · Maple Grove, MNBuilt 2016 · S/N 525-0919N1BZL2 Operations LLC · Saint Paul, MNBuilt 2001 · S/N 525-0439N1FMCokelet LLC · South Padre Island, TXBuilt 1997 · S/N 525-0218N1JWRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1982 · S/N 200N1KTEkfj LLC · Waco, TXBuilt 1978 · S/N 230N1NLNeil F Lampson Inc · Kennewick, WABuilt 1998 · S/N 550-0857N1SVJtl Leasing Co LLC · Kalispell, MTBuilt 1980 · S/N 550-0150N1TWNasa 805 LLC · Whitefish, MTRegistration expired, pending cancellationBuilt 1982 · S/N 476N1TYOwens Scotty · Crofton, KYBuilt 1980 · S/N 550-0171N1UMUniversity Of Mississippi · University, MSBuilt 2000 · S/N 560-0543N1YMSupreme Aeronautics LLC · Haymarket, VAS/N D-1145N2000Global Avionics LLC · Downey, CAS/N 56N2000X4thd LLC · Midland, TXBuilt 1994 · S/N 560-0249N200ASRha Air LLC · North Little Rock, ARBuilt 2000 · S/N 550-0934N200FJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1980 · S/N 408N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336N200NCMidwest Jet LLC · Lynd, MNBuilt 1980 · S/N 550-0184N200NSContinental Land Co LLC · Wilmington, DEBuilt 2000 · S/N 550-0949N200SLAtfo LLC · Wildwood, MOBuilt 2001 · S/N 525-0461N200WKSkyview LLC · Wilmington, DEBuilt 1976 · S/N 261N200WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 352N201BRSky Bus Inc · North Miami Beach, FLBuilt 1968 · S/N 166N201SUImp Inc · Coatesville, PANon-citizen corporation, flight hours not reportedBuilt 2001 · S/N 560-0586N202DKarschney Rich · Pateros, WABuilt 1947 · S/N D-57
Back to AD 97-05-03 R1