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.

N525USRegistered aircraftBuilt 2025 · S/N 525-1404N525VDelair LLC · Arden, NCBuilt 2022 · S/N 525-1127N525WBContec Inc · Spartanburg, SCBuilt 1994 · S/N 525-0079N525WCOption Air LLC · Lawrence, MABuilt 1995 · S/N 525-0107N525WEMv Flight Services LLC · Weslaco, TXBuilt 2015 · S/N 525-0892N525WFKentucky Aviation Solutions LLC · Frankfort, KYBuilt 1998 · S/N 525-0246N525WRCas Aircraft LLC · Bossier City, LABuilt 1993 · S/N 525-0034N525WWN525ww LLC · Millsboro, DEBuilt 1994 · S/N 5250060N525WXXsurgo Aviation Inc · Nashville, TNBuilt 2017 · S/N 525-0957N525XDOuter Reef LLC · Bend, ORBuilt 1999 · S/N 525-0335N525XPFull Send Aviation LLC · Wilmington, NCBuilt 2022 · S/N 525-1131N5263Big River Aviation LLC · Bonne Terre, MOBuilt 1997 · S/N 560-0435N526ABAmandair LLC · Concord, MABuilt 2018 · S/N 525-1012N526MDBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 525-0604N527MStevenson Leasing LLC · Kansas City, KSBuilt 2022 · S/N 525-1107N527PTSatelite Industries Inc · Minneapolis, MNBuilt 2018 · S/N 525-0999N527RYVesta Faye Leasing LLC · Abbott, TXBuilt 1990 · S/N 5600061N528BCBeech Creek Coal Corp · Roanoke, VABuilt 1993 · S/N 560-0230N528DXXitp LLC · Newark, DEBuilt 2000 · S/N 550-0906N528KWDavenport Financial Group Inc · Oklahoma City, OKBuilt 1993 · S/N 560-0224N528LButler National Inc · Olathe, KSS/N 528N528MXCombined LLC · Helena, MTBuilt 2005 · S/N 258725N5298XLawtx Travel LLC · Houston, TXBuilt 2001 · S/N 525-0440N529FDDft LLC · Central Point, ORBuilt 1997 · S/N 525-0192N529TATodhunter Aviation LLC · Wilmington, DEBuilt 2019 · S/N 525-1037N529TGJet Connection LLC · Hamilton, OHBuilt 1999 · S/N 560-0497N52FNGh Equipment LLC · Dover, DEBuilt 1981 · S/N 424N52KXZb Air LLC · Broken Arrow, OKBuilt 1998 · S/N 525-0287N52LTBc Aero Holdings LLC · Dover, DEBuilt 1982 · S/N 550-0355N52NWCsc Deleware Trust Trustee · Wilmington, DES/N 645N52WFBas Part Sales LLC · Greeley, COBuilt 1999 · S/N 560-0528N52ZGLift Aviation LLC · Aspen, COBuilt 2015 · S/N 525-0891N530DLTaylor Aero LLC · Lewes, DES/N 287N530SEHill Country Jet Partners LLC · Spicewood, TXBuilt 1981 · S/N 454N531BROvation Of Columbia LLC · Augusta, GAS/N 525-0264N531FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 113N531THCrimson Skies LLC · Pelham, ALBuilt 2001 · S/N 5500990N535Citation Jet 535 LLC · Moultrie, GABuilt 2001 · S/N 525-0445N535BPBum Aviation LLC · Green Bay, WIBuilt 2003 · S/N 560-0646N535MPLouisville Aviation LLC · Louisville, KYS/N 550-0179N539JMN539jm LLC · Clovis, NMBuilt 1995 · S/N 560-0339N53DDResort Air LLC · Honolulu, HIBuilt 1992 · S/N 550-0711N53FNGh Equipment LLC · Dover, DEBuilt 1977 · S/N 118N53FPDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 550-0434N53KVBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 525-0030N53KWWiley Bob Inc Trustee · Troy, ALS/N 028N53LPN53lp LLC · Amarillo, TXBuilt 1996 · S/N 560-0375N53PE3cap Aviation LLC · Scottsdale, AZBuilt 1998 · S/N 560-0464N53SMClayton Leasing Inc · Aberdeen, MSBuilt 1996 · S/N 560-0353N53STBlue Link LLC · Bay City, WIBuilt 2002 · S/N 560-0624
Back to AD 97-05-03 R1