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.

N3269VRegistered aircraftBuilt 1947 · S/N D-717N326JKRiver Bank Aviation LLC · Dover, DEBuilt 2003 · S/N 525-0511N3271VRiley Daniel B · Valparaiso, INBuilt 1947 · S/N D-720N3273VRoberts Alan P · Bolivar, MOBuilt 1947 · S/N D-722N3276VGrubbs Terry · Gregory, SDBuilt 1947 · S/N D-725N327HWN327hw LLC · Amarillo, TXS/N 560-0373N3288VSimmons Shawn Noral · Fort Rock, ORS/N D-739N328CJRegistration Pending · College Grove, TNRegistration pendingBuilt 1999 · S/N 525-0328N328PCSn 328 Corp · Fort Lauderdale, FLS/N 328N329PVN329pvrtbkcitation5 LLC · Las Vegas, NVBuilt 1991 · S/N 560-0140N32BBGee Aviation Inc · Sturgis, KYBuilt 2019 · S/N 525-1026N32HMAir Mellon LLC · Wilmington, DEBuilt 1983 · S/N 499N32KBS S K Hawker Group LLC · New Haven, CTBuilt 2000 · S/N 258461N32MJAviation Company Inc · Cheyenne, WYBuilt 1982 · S/N 460N32SMValley Air Service Inc · Wayne, ILBuilt 1983 · S/N 550-0478N3300VJacobsen Glenn D · Plano, ILBuilt 1947 · S/N D-759N3304VConklin Greg · Nevada City, CABuilt 1947 · S/N D-763N3306VHart Aviation LLC · Emory, TXS/N D-765N3307VAgogi Learning Systems LLC · Dahlonega, GABuilt 1947 · S/N D-766N3308VRobb Steven G · Riverside, CABuilt 1947 · S/N D-767N3309VArjad Henry · Irvine, CAS/N D-768N330DKBlue Canyon Ventures LLC · Elgin, SCBuilt 1981 · S/N 5500266N330VPJ & N Leasing LLC · Spokane, WABuilt 1995 · S/N 560-0330N3317VMathews Thomas R · Indianapolis, INBuilt 1947 · S/N D-777N331AAAsher Aviation Group LLC · Durango, COBuilt 1989 · S/N 560-0008N331BRBuffalo Bayou Air LLC · Houston, TXBuilt 1999 · S/N 560-0530N331GGGed Jet LLC · Boca Raton, FLBuilt 1999 · S/N 525-0353N331MW331 Mike Whiskey LLC · Scottsbluff, NEBuilt 1996 · S/N 560-0384N331PRAmerican Mine Research Inc · Rocky Gap, VABuilt 1998 · S/N 550-0831N3320VFricke Albert G · Lomita, CABuilt 1947 · S/N D-780N3329VMcmahon Jeffrey J · Paris, KYBuilt 1947 · S/N D-790N332MTOregon Trail Eye Center Pc · Scottsbluff, NEBuilt 2005 · S/N 550-1105N3333VBarreto David · Beavercreek, OHBuilt 1947 · S/N D-795N3337VStrong Don E Jr · Milano, TXS/N D-799N333KEFalconmitch Inc · Sulphur Springs, TXBuilt 1974 · S/N 14N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669N333SLT C Air LLC · West Linn, ORBuilt 2021 · S/N 525-1083N333XAJetnexa One LLC · Gilbert, AZBuilt 2015 · S/N 525-0889N3342VRichards James D · Nucla, COBuilt 1947 · S/N D-805N3346VBarnd Dennis Allen · Manchester, OHBuilt 1947 · S/N D-810N3355VRyan Kevin · Bethel, OHBuilt 1947 · S/N D-819N335CSHessjet LLC · Mc Donald, TNBuilt 2004 · S/N 550-1091N335KBShelt William J · Denton, TXS/N 588N335PRGy Aircraft LLC · Daytona Beach, FLBuilt 1989 · S/N 647N335RCN335 Aviation Corp · Middletown, DEBuilt 1979 · S/N 256N335RJWings II LLC · Birmingham, ALBuilt 2003 · S/N 550-1063N3361VMatta Figueroa Eduardo · Chapman, KSBuilt 1947 · S/N D-827N3365VReffett John S · Eagle River, AKBuilt 1947 · S/N D-831N336RHDylan Dublin Air LLC · Fort Pierce, FLBuilt 1979 · S/N 465-10N337LRJetsteam Aviation Inc · Cheyenne, WYBuilt 1981 · S/N 337
Back to AD 97-05-03 R1