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.

N123EDFrench Fly LLC · San Jose, CAS/N 258366N123EGButler Brian S · Oklahoma City, OKS/N 306N123RCBwa Westwind 2 LLC · Orlando, FLS/N 349N1249PTrns Solutions LLC · Lewes, DEBuilt 1982 · S/N 550-0451N124BGAdvance Jets LLC · Cincinnati, OHBuilt 1999 · S/N 525-0345N124PMMc Air LLC · Mobile, ALBuilt 2004 · S/N 550-1090N124RSHenley Charles D · New London, NCBuilt 1947 · S/N D-1212N1250VAquila Air LLC · Cincinnati, OHS/N 550-0439N12549Surdex Corp · Chesterfield, MOS/N 550-0501N1255KCypress Aircraft Sales LLC · Clermont, FLS/N 550-0505N125DWMcis Aviation LLC · Wilmington, DEBuilt 2021 · S/N 525-1095N125RGAero South Florida Corp · West Palm Beach, FLBuilt 1981 · S/N 550-0248N125XPN125xp LLC · Wilmington, DEBuilt 2000 · S/N 258485N126TFFox Lumber Sales Inc · Hamilton, MTBuilt 1997 · S/N 550-0815N127CLWyoming Aviation LLC · Sheridan, WYBuilt 1978 · S/N 550-0007N127GKAlliance Aviation Group LLC · Wilmington, DES/N 311N127JMN127jm LLC · Clovis, NMBuilt 1981 · S/N 550-0253N127MJZacj LLC · Zanesville, OHBuilt 1998 · S/N 525-0266N127PTN325nw LLC · Lodi, OHBuilt 1981 · S/N 337N127RGKlsit US Holdings LLC · Williams Bay, WIBuilt 2000 · S/N 550-0917N127ZAMagic Carpet LLC · Wilmington, DEBuilt 2002 · S/N 550-1032N129LTTnl Management LLC · Cullman, ALBuilt 1997 · S/N 550-0821N129PBSmaf Environmental LLC · Prineville, ORBuilt 2001 · S/N 550-0973N129RPN129rp LLC · Tulsa, OKBuilt 2000 · S/N 550-0928N129TKBankair Inc · West Columbia, SCBuilt 1979 · S/N 253N12GYValiair Limited Co Trustee · Casper, WYBuilt 2000 · S/N 525-0374N12JEProfessional Pilot Training Inc · Eagle Lake, TXBuilt 1980 · S/N 550-0185N12LDSouth Georgia Motor Sports LLC · Wilmington, DES/N 560-0527N12NSCbi Equipment LLC · Tualatin, ORS/N 525-1063N12RLPumpkin Patch Aviation LLC · Kodak, TNBuilt 2026 · S/N 525-1409N12RPRoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 278N13092Nxt LLC · Oklahoma City, OKBuilt 2006 · S/N 560-0707N130YBMwl Aviation 1 LLC · Miami Lakes, FLBuilt 2002 · S/N 258590N131PLPd Aero LLC · Oronogo, MOBuilt 1994 · S/N 525-0057N131RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 560-0366N1327JAbsolute Altitude LLC · Bellefontaine, OHBuilt 1993 · S/N 525-0009N133EJHale William Trustee · Loveland, COBuilt 1977 · S/N 133N133GLHs Air LLC · Little Rock, ARBuilt 1993 · S/N 525-0001N133KSJyh Aviation LLC · Jacksonville, FLBuilt 2004 · S/N 258697N133MGolden Age Flight Museum · Bakersfield, CAS/N D-557N134CJSkyview LLC · Wilmington, DES/N 134N135AJN135aj LLC · Englewood, COBuilt 1975 · S/N 036N135SHMed Air LLC · Wilmington, DEBuilt 1981 · S/N 335N135WCSdac Air LLC · Selma, ALBuilt 1994 · S/N 5600261N136JPCasmos LLC · Wilmington, DES/N 35A-359N136MVTransnet Aviation Group LLC · Short Hills, NJBuilt 2001 · S/N 311N137GJSolomon Mark Trustee · Wilmington, DEBuilt 1968 · S/N 25N137JCBcaf LLC · Indialantic, FLBuilt 1991 · S/N 560-0137N138CAPresidio Citation Bravo LLC · Chicago, ILBuilt 1999 · S/N 550-0900N139RNIsland Air Operations LLC · Wilmington, DEBuilt 1999 · S/N 550-0886
Back to AD 97-05-03 R1