OpenAirDocs.org
AD 97-05-03 R1

Registered aircraft · 2,862

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.

N621KMEjair LLC · Conway, ARBuilt 1998 · S/N 550-0842N621SBHundredfold Seraphim LLC · Miami Lakes, FLBuilt 2001 · S/N 258531N622PGCapital Craft LLC · Wilmington, DEBuilt 1978 · S/N 550-0037N622SLCommander Properties Inc · Wilmington, DEBuilt 2006 · S/N 525-0622N622TFN9cr LLC · Hilton Head Island, SCBuilt 2002 · S/N 560-0622N624PLLow Tide LLC · Riverside, IABuilt 1982 · S/N 550-0402N624PWK3m Leasing LLC · Tyler, TXBuilt 2008 · S/N 560-0792N625ACAir Fiber LLC · Black Rock, ARBuilt 1994 · S/N 5600251N625CYCite Aviation LLC · Wilmington, DES/N 625N625PGN625pg Corp Trustee · Wilmington, DEBuilt 1998 · S/N 525-0282N625WAPhoenix Helicopters LLC · Dover, DEBuilt 1989 · S/N 560-0027N626BMRegistered aircraftBuilt 1989 · S/N 634N626CVCvi Aircraft Leasing LLC · Coldwater, MIBuilt 2006 · S/N 525-0626N626RBMillard Robert B · Stratford, CTBuilt 1993 · S/N 560-0221N626RMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 525-0969N626TMJj'S Jet LLC · Zanesville, OHBuilt 1999 · S/N 525-0307N627BCHard Eight Investments LLC · Alpharetta, GABuilt 1999 · S/N 5500868N627GBRose Isle Aviation LLC · Orlando, FLBuilt 2016 · S/N 525-0930N627MW627mw LLC · Wilmington, DEBuilt 2006 · S/N 525-0627N628GBMmx LLC · Chesapeake, VABuilt 2001 · S/N 550-0991N628TMFedair LLC · Indianapolis, INBuilt 1993 · S/N 525-0010N629FFAllen Teinert Construction Co · Lubbock, TXBuilt 1998 · S/N 560-0490N62MBWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 282N62RARoyal Air Freight Inc · Waterford, MIS/N 312N62TLDialysis Clinic Inc · Nashville, TNBuilt 1983 · S/N 550-0462N630SPAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1981 · S/N 550-0237N630TKN630tk LLC · Clovis, NMBuilt 1991 · S/N 560-0155N631TSLettuce Fly LLC · King City, CABuilt 1990 · S/N 5500631N632GUFlyarnd LLC · Tyler, TXBuilt 2001 · S/N 560-0562N633LGJ A Miara Transportation Inc · Wilmington, MABuilt 2018 · S/N 525-0992N633PCDjd Aero LLC · Lubbock, TXBuilt 2004 · S/N 550-1085N633RSTsc Logistics LLC · Destin, FLBuilt 1991 · S/N 560-0114N635RJRoyal Air Freight Inc · Waterford, MIBuilt 1975 · S/N 35-017N637ATN637at LLC · Punta Gorda, FLBuilt 1979 · S/N 5500371N638GMSkytrain Aviation LLC · Dallas, TXBuilt 2008 · S/N 560-0785N63FFFuntime63ff LLC · Bozeman, MTBuilt 1990 · S/N 560-0063N63JG63jg LLC · Colorado Springs, COBuilt 1992 · S/N 560-0189N63RAEncore Aviation LLC · Indian Trail, NCBuilt 2006 · S/N 550-1125N63TKBeaver N63tk LLC · Salem, ORBuilt 1997 · S/N 550-0803N63TRRj Air LLC · Irvine, CABuilt 2017 · S/N 525-0956N63YASarasbrij International Inc · Wilmington, DES/N 525-0830N63YMSun Country Products LLC · Tampa, FLBuilt 2003 · S/N 258636N640YBluebonnet Aviation Club LLC · San Marcos, TXBuilt 1988 · S/N 550-0590N643RTOld Glory Leasing LLC · Fargo, NDBuilt 1989 · S/N 560-0019N644CKKalitta Charters LLC · Ypsilanti, MIBuilt 1988 · S/N 644N646VPM2 Aviation LLC · Pasadena, TXBuilt 2007 · S/N 525-0646N648ASale Reported · Chicago, ILSale reportedBuilt 2004 · S/N 560-0657N648HERocket Air LLC · Carson City, NVBuilt 1997 · S/N 525-0219N649TTTownes Aircraft Sales LLC · Paris, TXBuilt 2005 · S/N 342N64CFContrails 35 LLC · El Cajon, CAS/N 461
Back to AD 97-05-03 R1