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.

N272DNDel Mar College · Corpus Christi, TXBuilt 1978 · S/N 135N273Lone Star Sorties LLC · Dickinson, TXS/N D-1340N2736VHatloy Mark A · Drayton, NDBuilt 1947 · S/N D-116N2751VGarrett Gregory Todd · Athens, TXBuilt 1947 · S/N D-136N2754VSheldon Paul T · Saint James, MNS/N D-139N2762VJ R Bane Land Corp · Oakland, IABuilt 1947 · S/N D-153N2766KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 258744N2766VReady Aim Flyer LLC · New Castle, DEBuilt 1947 · S/N D-157N2772VCathcart Samuel H · Carlisle, OHBuilt 1947 · S/N D-164N2778VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-170N277MKCasmos LLC · Wilmington, DEBuilt 1980 · S/N 341N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693N2785VGunnarsson Jon · Concrete, WAS/N D-177N2786VHoffner Edward M · Jefferson City, TNBuilt 1947 · S/N D-178N278KThienes Engineering Inc · La Mirada, CABuilt 2003 · S/N 525-0527N2795VBas Part Sales LLC · Greeley, COBuilt 1947 · S/N D-190N2798VPorte Elvis · Miami, FLBuilt 1947 · S/N D-193N279CFJ Jets Inc · Dover, DES/N 258642N27CJ411kc LLC · Tuscaloosa, ALBuilt 1999 · S/N 525-0311N27EWTextron Aviation Inc · Wichita, KSS/N 525-1425N27TZSparrow Aircorp Inc · Dover, DEBuilt 1977 · S/N 213N2804VPlumcrazy Aviation LLC · Ellenboro, NCBuilt 1947 · S/N D-201N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332N280PMCommand Decisions Inc · San Angelo, TXBuilt 1980 · S/N 5500188N2813VAdair Edward A · Hemet, CABuilt 1947 · S/N D-214N2819VElgin Sky Snoopers Inc. · Crystal Lake, ILBuilt 1947 · S/N D-221N2820VLundstedt Garry R · Fort Collins, COBuilt 1947 · S/N D-222N2821VSchmitt Rudy · Brookshire, TXBuilt 1947 · S/N D-225N2824VBigfoot Aviation LLC · Saint Michael, MNBuilt 1947 · S/N D-228N282HVN282hv LLC · Amarillo, TXBuilt 1994 · S/N 560-0282N282TRed Star Aero Holdings LLC · Lewes, DEBuilt 1974 · S/N 42N2834VKieper Mark A · Hampton, MNBuilt 1947 · S/N D-239N283DFTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1983 · S/N 5500456N2846VRegistration Pending · Shawnee, OKRegistration pendingS/N D-251N284HSAxis Aviation LLC · Boerne, TXBuilt 1995 · S/N 560-0305N2855VBunka Donald P · Fenton, MIBuilt 1947 · S/N D-260N2858VMyers Alyssa L · Clayton, NMS/N D-263N285CC3kd LLC · Wilmington, DEBuilt 1995 · S/N 560-0285N285XPAviation Fjaf LLC · Davie, FLBuilt 1995 · S/N 258285N2860VNord Aviation Inc · Pembina, NDBuilt 1947 · S/N D-265N2861VBeck Roger M Trustee · Goode, VABuilt 1947 · S/N D-266N2868VBiehle Michael A · Yuba City, CABuilt 1947 · S/N D-273N2870VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N D-275N287CBCottingham & Butler Insurance Services Inc · Dubuque, IABuilt 2017 · S/N 525-0942N288HLJbm Equipment Leasing LLC · Center, TXBuilt 2002 · S/N 560-0599N2896VKenyon Joseph S · Fort Collins, COS/N D-304N2897DMiller Earl R · Gig Harbor, WABuilt 1947 · S/N D-898N2897VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N D-305N2899VMtv Aero Group · Pauls Valley, OKS/N D-307N289AWAir Gato Enterprises Inc · Clearwater, FLBuilt 1987 · S/N 628
Back to AD 97-05-03 R1