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.

N85SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 347N85TNLls Aviation LLC · Nederland, TXBuilt 1993 · S/N 237N85VRBd Charters LLC · Henderson, TXBuilt 2001 · S/N 525-0425N85WHM Hixson Aviation LLC · Lake Dallas, TXBuilt 2021 · S/N 525-1088N860CRGulf Atlantic Airways Inc · Gainesville, FLBuilt 1999 · S/N 560-0500N860DBWhyriverranch LLC · Mc Leod, MTBuilt 2001 · S/N 525-0434N861CGLolaire LLC · El Dorado Hills, CABuilt 2015 · S/N 525-0861N862KN862k LLC · Houston, TXBuilt 1981 · S/N 550-0257N863JBPj One LLC · Land O Lakes, FLBuilt 1994 · S/N 560-0260N864AMAirmed International LLC · Birmingham, ALBuilt 2005 · S/N 258733N864BFPsx LLC · Sheridan, WYBuilt 2002 · S/N 258584N864DCPgv LLC · Camden, DEBuilt 2003 · S/N 258647N864HABravo Preferred Partners LLC · Solon, OHBuilt 1999 · S/N 550-0864N866TCJetz Service Co Inc · Topeka, KSS/N 560-0802N867JCWoodbine Aviation LLC · Lewes, DEBuilt 1980 · S/N 550-0166N867TXAirplane 1 LLC · Richmond, TXBuilt 2002 · S/N 258576N868CWBig Sky Insulations Inc · Belgrade, MTBuilt 2007 · S/N 560-0757N868PZPvaa LLC · Dover, DEBuilt 2003 · S/N 258633N869CBHpg Holdings LLC · Mesa, AZS/N 525-0453N86PCLos Veranos Companies LLC · Irvine, CAS/N 550-0891N86TNBravo Aviation LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 241N86URMsr Investment Properties LLC · Brentwood, TNBuilt 1988 · S/N 550-0589N870BTdc Transportation LLC · Sylvania, OHS/N 550-0870N870CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 170N870TXN870tx LLC · Fort Lauderdale, FLBuilt 2006 · S/N 258763N872JPJssi Parts LLC · Chicago, ILS/N 550-0872N876BBKc & Sc LLC · Forest, VABuilt 2004 · S/N 550-1087N876JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 560-5048N876MSAvoboe LLC · North Little Rock, ARBuilt 2015 · S/N 525-0876N876UStewart James G Trustee · Pacifica, CABuilt 2018 · S/N 525-0997N8778Ligon Air LLC · Birmingham, ALBuilt 2001 · S/N 258560N878CHBruce Alexander Company LLC · Elkhart, INBuilt 2003 · S/N 550-1067N878JUfly LLC · Wilmington, DEBuilt 2005 · S/N 525-0608N878MBMb Air LLC · New York, NYBuilt 2002 · S/N 258603N878RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 525-0914N879SADouma LLC · Santa Teresa, NMBuilt 2022 · S/N 525-1129N87KBKkb Holdings LLC · Wilmington, DEBuilt 2003 · S/N 331N87RBDpm Aviation LLC · Noblesville, INBuilt 1996 · S/N 258299N87RTPremier Lj40 Inc · Wilmington, DEBuilt 1977 · S/N 106N87SFSeneca Foods Corp · Penn Yan, NYBuilt 2002 · S/N 560-0616N880PLExecutive Air Taxi Corp · Bismarck, NDBuilt 1998 · S/N 258380N880PSVientos Air LLC · Santa Fe, NMBuilt 1996 · S/N 560-0398N880ZMed Jet LLC · El Cajon, CAS/N 591N881AFPetrotransit LLC · Cypress, TXBuilt 1996 · S/N 258289N881RCCooper Companies Inc · Scottsdale, AZBuilt 2007 · S/N 525-0635N881SJEdwards Pacific Aviation Corp · Dover, DES/N 550-0958N882MZ7-Star Aviation LLC · Addison, TXBuilt 2015 · S/N 525-0882N882SCAti Jet Inc · El Paso, TXBuilt 1984 · S/N 590N882WFSotex II LLC · Midland, TXBuilt 1999 · S/N 550-0882N882YDDodson International Parts Inc · Rantoul, KSS/N 140
Back to AD 97-05-03 R1