OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,028

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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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.

N7758GGallo Enterprises Inc · Wonder Lake, ILBuilt 1970 · S/N 17259458N775PSkydive Seneca Lake LLC · Ovid, NYBuilt 1966 · S/N U206-0769N7760GLeriche Nicolette · Oceanside, NYBuilt 1970 · S/N 17259460N7761FSullivan Randall G · Liberty, TXBuilt 1966 · S/N 15063861N7762FCosta Air Service LLC · Painted Post, NYS/N 15063862N7763FRoss Joshua S · Homer, AKBuilt 1966 · S/N 15063863N7764FAbouhatab Majed · Houston, TXBuilt 1966 · S/N 15063864N7764GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259464N7765FFilippone Chrristopher A · Ormond Beach, FLS/N 15063865N7765GJefferies Stanley J · Coos Bay, ORBuilt 1970 · S/N 17259465N7766FBuckman Bill · Lorenzo, TXBuilt 1966 · S/N 15063866N7766GAir Ally Asset Management LLC · Chisago City, MNS/N 17259466N7767FMorris Donald R · Murphysboro, ILS/N 15063867N7767GPerformance Aviation LLC · Fort Myers, FLBuilt 1970 · S/N 17259467N7770ASampson Zachary J · New Braunfels, TXS/N 17252309N7770GMyers Keith R Trustee · Fond Du Lac, WIBuilt 1970 · S/N 17259470N7771GEmpire Aero Club Inc · Sebastopol, CABuilt 1970 · S/N 17259471N7772FCushing Aviation LLC · Red Wing, MNBuilt 1966 · S/N 15063872N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472N7773FDux Aaron T · Missoula, MTS/N 15063873N7774ASaydun LLC · Richardson, TXBuilt 1964 · S/N 17252168N7774BAdair Aviation LLC · Broken Arrow, OKBuilt 1981 · S/N U20606224N7774CTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1973 · S/N 0093N7774FMurphy Jeffrey R · Newport, MNS/N 15063874N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476N7778Carpenter Darrell W · Midland City, ALBuilt 1973 · S/N 177RG0349N7779FSmith Brian · Richmond, INBuilt 1966 · S/N 15063879N777DUSc Infinities LLC · Dover, DEBuilt 1971 · S/N 17259854N777GTShillings Phillip J · Goldthwaite, TXS/N 21058339N777NYJohanson Jason M · Groveland, CAS/N U20605051N777RGLow Matthew N · Clearwater, FLBuilt 1968 · S/N 18258774N777WLAerospace Trust Mangement LLC Trustee · Wilmington, DEBuilt 1970 · S/N 21059376N777WRFoley James V · Houston, TXBuilt 1962 · S/N 18253913N777ZCDiversified Refrigeration Co · Lino Lakes, MNBuilt 1966 · S/N 18256985N7780FDuquette Stephen R · Fenton, MIS/N 15063880N7780GAero Quest LLC DBA · Olive Branch, MSBuilt 1970 · S/N 17259480N7781GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259481N7782FLewis Wayne · Martin, TNBuilt 1966 · S/N 15063882N7783FMiller Patrick G · Homer, AKBuilt 1966 · S/N 15063883N7784FSelf Edwin C · Columbia, TNBuilt 1966 · S/N 15063884N7784GAll2fly LLC · Atlanta, GABuilt 1970 · S/N 17259484N7786GRcm Aviation LLC · North Clarendon, VTFirst renewal noticeBuilt 1970 · S/N 17259486N7788FGerig David J · Woodburn, INBuilt 1966 · S/N 15063888N7789FSutton George R · Big Bear City, CABuilt 1966 · S/N 15063889N778RDKilo Golf Aviation LLC · St Simons Island, GABuilt 1976 · S/N 17702550N7792FBas Part Sales LLC · Greeley, COS/N 15063892N7794FWhitman Larry C · Hinesville, GABuilt 1966 · S/N 15063894N7796FLucarelli David L · Moncks Corner, SCBuilt 1966 · S/N 15063896
Back to AD 72-03-03 R3