AD 72-03-03 R3

Registered aircraft · 17,027

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.

N61253Flight Gate LLC · Wilton, CAS/N 15070918N61259Lund Michael J · Poulsbo, WABuilt 1969 · S/N 15070924N6125FParker Richard A · West Chicago, ILBuilt 1968 · S/N 21059025N6126FCarson John D · Garber, OKBuilt 1968 · S/N 21059026N6126RKelley Kal · Colville, WAS/N T210-0026N6127FSmith Phillip · Osprey, FLBuilt 1968 · S/N 21059027N6127RPhillips Bill · Galt, CABuilt 1965 · S/N T210-0027N61282Trimble David G · Vici, OKBuilt 1969 · S/N 15070939N61286Houseman Jeffery D · Millersville, MOBuilt 1966 · S/N 15063430N61288Vanorman Curt M · Clarkesville, GABuilt 1969 · S/N 15070944N6128ROhop Robert D · Jones, OKBuilt 1965 · S/N T210-0028N61296Coomes Scott F · Seattle, WABuilt 1969 · S/N 15070947N61297Highway Jet League Flyers Brotherhood LLC · Allouez, WIBuilt 1969 · S/N 15070948N6129GPeters William E · Bel Air, MDBuilt 1970 · S/N 15071629N6129RIncline Engineering And Consulting LLC · Ovalo, TXBuilt 1965 · S/N T210-0029N612DMRegistered aircraftBuilt 1977 · S/N 177RG1212N612HKDickey Stephen H · De Leon, TXBuilt 1977 · S/N 177RG1303N6130FBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 21059030N6130RHarris Phillip S · Greenwood Village, COS/N T210-0030N61311Wood James A · Madera, CABuilt 1969 · S/N 15070955N6131FLundell Brandon M · Lyons, COBuilt 1968 · S/N 21059031N6131GCragg Gordon E · Georgetown, TXBuilt 1969 · S/N 15071631N6131RAir LLC · Salem, ORS/N T210-0031N61321Gerdes Brian K · Los Alamitos, CAS/N 15070963N61324Wills Evan J · Lynnwood, WABuilt 1969 · S/N 15070964N61325Zetir Mohamad · Oviedo, FLBuilt 1969 · S/N 15070965N61329Girls Love To Fly Inc · Roseville, CABuilt 1969 · S/N 15070969N61333Gustafson Michael J · Minnetonka, MNBuilt 1969 · S/N 15070972N61336Evans David C · Thousand Oaks, CABuilt 1969 · S/N 15070973N61338Flyit LLC · Camas, WABuilt 1969 · S/N 15070975N61345Carlson Brent A · Shelley, IDS/N 15070980N61354New Vision Aviation · Fresno, CABuilt 1969 · S/N 15070985N6135FJr Imaging Logistics Inc · Pasco, WABuilt 1973 · S/N A1500423N61363Hulbert Stephen R · Fort Ransom, NDBuilt 1969 · S/N 15070989N61365Plane Progress LLC · Waterloo, IABuilt 1969 · S/N 15070990N6137FWingland Inc · Los Angeles, CABuilt 1968 · S/N 21059037N6137GPiersol Benjamin T · Honey Brook, PABuilt 1969 · S/N 15071637N6138FSchlegelmilch Scott A · Elkhorn, NEBuilt 1968 · S/N 21059038N6138GStrange Keith · Lincoln, MEBuilt 1969 · S/N 15071638N613WDCruse Josiah L · Rainier, ORBuilt 1969 · S/N 18259805N6140FFluno John I · San Rafael, CAS/N A1500425N6140GSmoketown Flight Center LLC · Smoketown, PABuilt 1969 · S/N 15071640N6143GSale Reported · Brodhead, WISale reportedBuilt 1969 · S/N 15071643N6144GHoke Christopher R · Kernersville, NCS/N 15071644N6145FAlpha Bravo Aviation LLC · Trophy Club, TXBuilt 1973 · S/N A1500426N6146FHeppner Sebastian · Fishers, INS/N A1500427N6147FHenry Charles C · Portland, TNBuilt 1968 · S/N 21059047N6148FWorsham Eric S · La Porte, TXS/N 21059048N6150GStockton Raymond L · Pearl City, HIBuilt 1969 · S/N 15071650N6151RPath Barney H DBA · Claremont, CABuilt 1965 · S/N T210-0051
Back to AD 72-03-03 R3