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.

N337WRAer Sales Lp · Carrollton, TXBuilt 1995 · S/N 258273N3380VCarney Francis P · Eloy, AZS/N D-848N3387VPermian Basin Blue Sky Inc · Odessa, TXBuilt 1947 · S/N D-861N338RSr Air LLC · Schamburg, ILBuilt 1995 · S/N 560-0338N3391VWelsh Kevin J · Roseburg, ORS/N D-865N3394VDavis Sherald L · Baytown, TXS/N D869N3398VWiger Theodore L · Falcon Heights, MNBuilt 1947 · S/N D-873N339AVKmwflight LLC · Wilmington, DEBuilt 1994 · S/N 258255N33BCSworks Aviation LLC · Chicago, ILBuilt 1996 · S/N 258292N33DTN33dt LLC · Phoenix, AZBuilt 1995 · S/N 525-0080N33EKEastview Properties LLC · Memphis, TNBuilt 1981 · S/N 550-0281N33FWNext Level Aviation Group LLC · Sarasota, FLBuilt 1997 · S/N 525-0203N33JWBj Aviation LLC · Beaver Meadows, PABuilt 1974 · S/N 306-92N33NMBighorn Airways Inc · Sheridan, WYBuilt 1993 · S/N 5250025N33PXAirtime LLC · Mont Belvieu, TXBuilt 2002 · S/N 560-0614N33RCBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 258466N33TRAirborne Holdings Inc · Midlothian, TXBuilt 1980 · S/N 465-47N33TWPolytech Adult Education · Woodside, DES/N 316N3403VBernier Brian Matthew · Austin, TXBuilt 1947 · S/N D-879N3405VRegistration Pending · Salem, MORegistration pendingBuilt 1947 · S/N D-881N341ARMla Management LLC · Salt Lake City, UTBuilt 1999 · S/N 525-0341N342AJFlightpath Aviation Services Inc · Brooksville, FLBuilt 1979 · S/N 5500050N343SCMtj Aviation LLC · Mooresville, NCBuilt 1998 · S/N 258365N345TRJog068 Inc · Lewes, DEBuilt 1981 · S/N 345N346EXWebair LLC · Warrenton, VAS/N 346N347BCRoni 1 LLC · Sacramento, CABuilt 2001 · S/N 525-0431N347GAJp Flying LLC · Dover, DEBuilt 1981 · S/N 347N348AJE E & K C LLC · New Orleans, LABuilt 1997 · S/N 258334N348CMCavu Transportation LLC · Hayden, IDBuilt 2000 · S/N 550-0915N34RLKar2 Inc · Sevierville, TNBuilt 2017 · S/N 525-0948N34TCHuff Air LLC · Uvalde, TXBuilt 1994 · S/N 5250083N34TJAbove The Rest Aircraft Services LLC · Midlothian, TXBuilt 1975 · S/N 41N3509RAnalog Yankee LLC · Boulder, COBuilt 1989 · S/N 560-0024N350WCN350wc LLC · Clovis, NMBuilt 1994 · S/N 560-0266N351ASRoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 146N351BCInternational Bank Of Commerce · Laredo, TXBuilt 1996 · S/N 525-0159N351BFKbs Aviation LLC · Springboro, OHBuilt 2018 · S/N 525-0995N351CJSkyview LLC · Wilmington, DEBuilt 1982 · S/N 5500351N351PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N 074N351TXDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 127N352CCConcept Aviation Of North Florida Inc · Gainesville, FLBuilt 1991 · S/N 5600151N352CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 313N352PJPremier Jets Inc · Hillsboro, ORS/N 530N352PMEleven Eleven Holdings LLC · Middletown, DEBuilt 1981 · S/N 410N353CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 081N353JABasler Turbo Conversions LLC · Oshkosh, WIS/N 258729N354CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 353N354LQBrunner Aerospace LLC · Georgetown, TXBuilt 1976 · S/N 055N355CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 062N355KCN331us LLC · Hillsboro, ORBuilt 1982 · S/N 490
Back to AD 97-05-03 R1