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.

N525HMRegistered aircraftBuilt 2006 · S/N 525-0621N525HQN525hq Aircraft Holdings LLC · Mount Pleasant, SCBuilt 2014 · S/N 525-0827N525HSKen Dunbar & Sons Inc · Bakersfield, CABuilt 1993 · S/N 525-0035N525HXValiair Lc Trustee · Casper, WYBuilt 1998 · S/N 525-0278N525HYGp Farms LLC · Missoula, MTBuilt 1998 · S/N 525-0239N525JCj525j LLC · Millersburg, OHBuilt 1997 · S/N 525-0184N525JANewsome Jeff S · Blackwell, OKBuilt 1981 · S/N 550-0252N525JDCuprum Aviation LLC · Wellington, FLBuilt 2014 · S/N 525-0819N525JESimply Living LLC · Fort Myers, FLBuilt 2002 · S/N 525-0493N525JJReb Transporation LLC · Hattiesburg, MSBuilt 2002 · S/N 525-0497N525JLMadison Air LLC · Big Sky, MTBuilt 2000 · S/N 525-0407N525JMJ D Leasing LLC · Wilmington, DEBuilt 1996 · S/N 525-0134N525JVJ P Ferguson Aviation LLC · Oxford, MSBuilt 1995 · S/N 525-0095N525JWWashington Road Properties Level 2 LLC · Highlands, NCBuilt 1996 · S/N 525-0162N525KAPhysical Systems Inc · Carson City, NVBuilt 1993 · S/N 525-0019N525KBLast Bird LLC · Santa Fe, NMBuilt 2017 · S/N 525-0964N525KHKh Aviation Tbm 850 LLC · Prospect Heights, ILBuilt 2016 · S/N 525-0908N525KMYy LLC · Kalispell, MTBuilt 2001 · S/N 525-0472N525KSNt Aviation LLC · Wichita, KSBuilt 1993 · S/N 525-0024N525LAArkten Jet Partners LLC · Jonesboro, ARBuilt 2001 · S/N 525-0422N525LEJet Options LLC · Indianapolis, INBuilt 2001 · S/N 525-0447N525LKKovacs Louis Attila Trustee · Saratoga, CABuilt 1997 · S/N 525-0200N525LMCth Rentals LLC · Halls, TNBuilt 2001 · S/N 525-0427N525LPTeam Financial Inc · Birmingham, ALBuilt 1997 · S/N 525-0196N525LWN525lw Corp Trustee · Wilmington, DEBuilt 1994 · S/N 525-0082N525LXV2 Aviation LLC · Chattanooga, TNBuilt 1994 · S/N 525-0058N525MBPortobello LLC · Fort Payne, ALBuilt 1993 · S/N 525-0036N525MHFoster Time LLC · Midland, TXBuilt 2019 · S/N 525-1036N525MMRst Ventures LLC · Franklin, MIBuilt 2013 · S/N 525-0815N525MSBuilding Specialties Co Of Western Pennsylvania · Saxonburg, PABuilt 2018 · S/N 525-1004N525MWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 525-0370N525MXAmdel Holding LLC · Houston, TXBuilt 2001 · S/N 525-0423N525NCF & F Aviation LLC · Memphis, TNBuilt 2018 · S/N 525-0994N525NVBeers Investment Group Toys LLC · Saint Petersburg, FLBuilt 1994 · S/N 525-0072N525PEFliteaccess LLC · Louisville, KYBuilt 2002 · S/N 550-1031N525PGEvo Leasing LLC · Chandler, AZBuilt 2018 · S/N 525-0981N525PJAdirondack Jets LLC · Scottsdale, AZBuilt 2013 · S/N 525-0809N525PLRegistered aircraftBuilt 1994 · S/N 525-0043N525PTR&D Aviation LLC · Florence, ALBuilt 1995 · S/N 525-0125N525RAJackson Aviation LLC · Dayton, ORS/N 525-0167N525RCCerovest Capital LLC · Lawrenceville, GABuilt 1997 · S/N 525-0178N525RDGjjl Equipment LLC · Houston, TXBuilt 1991 · S/N 560-0106N525RKWest Chester Permit LLC · Cincinnati, OHBuilt 2001 · S/N 525-0413N525RMBenham James M · College Station, TXBuilt 1997 · S/N 525-0225N525RPBravo Foxtrot Aviation LLC · Tucker, GABuilt 1993 · S/N 525-0023N525RYBernoulli LLC · Inlet Beach, FLBuilt 2001 · S/N 525-0438N525SYQualitair LLC Trustee · MichelstadtS/N 525-0324N525TFSl Jet Cj LLC · Cleveland, TNBuilt 1994 · S/N 525-0067N525TGRoyal Air LLC · Glenwood Springs, COBuilt 2014 · S/N 525-0826N525UHTextron Aviation Inc · Wichita, KSS/N 525-1431
Back to AD 97-05-03 R1