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.

N2434JSkyhawk Aero LLC · Montevideo, MNS/N 15065534N2434LWeston Torey C · Unionville, MOBuilt 1966 · S/N 17255634N2434XJensen Shaun V · Anchorage, AKBuilt 1965 · S/N 18256334N2435JWitherspoon Jason C · Austin, ARBuilt 1966 · S/N 15065535N2435LAero Science International LLC · Augusta, GABuilt 1966 · S/N 17255635N2435QVolare Aviation LLC · Wylie, TXBuilt 1966 · S/N 18257635N2436RSilva Gary · Yerington, NVBuilt 1964 · S/N 18255536N2437RBlackwelder John W · Columbia, KYBuilt 1964 · S/N 18255537N2437XLudke Arnold · Oakland, NJBuilt 1965 · S/N 18256337N2438JVayner Anton · Shorewood, WIBuilt 1966 · S/N 15065538N2438XRousser Cattle LLC · Amarillo, TXBuilt 1965 · S/N 18256338N2439JHenderickson Robert T · Galesburg, ILBuilt 1966 · S/N 15065539N2439LBetts William B · Big Lake, AKS/N 17255639N2439XAlpha Aero LLC · Biddle, MTBuilt 1965 · S/N 18256339N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205N2440JOliver Tim J · San Luis Obispo, CABuilt 1966 · S/N 15065540N2440LEads Kevin C · Arley, ALBuilt 1966 · S/N 17255640N2441RBelly Acres Capital And Management LLC · Memphis, TNBuilt 1964 · S/N 18255541N2442JOlson Lanny R · Huron, SDS/N 15065542N2442LPratt Mark R · La Grande, ORBuilt 1966 · S/N 17255642N2443LOdlozil Henry W · Ennis, TXBuilt 1966 · S/N 17255643N2443QHolcomb Aviation LLC · Middleton, IDS/N 18257643N2443RYoung David E · Wasilla, AKBuilt 1964 · S/N 18255543N2444QBristow Christopher W · Fairfield, TXBuilt 1966 · S/N 18257644N2444RClancy Michael · Rifle, COBuilt 1964 · S/N 18255544N2444XRocha Frank N · Knights Ferry, CAFirst renewal noticeBuilt 1965 · S/N 18256344N2445XBald Eagle Aviation LLC · West Chester, PABuilt 1965 · S/N 18256345N2447QEaton James B · Green Bank, NJBuilt 1966 · S/N 18257647N2448QEuroaviation Inc Trustee · KematenS/N 18257648N2448XBlough Robert M · Hoonah, AKBuilt 1965 · S/N 18256348N2449LSteier Tim · Salome, AZBuilt 1966 · S/N 17255649N2449QAcme Aircraft Co III LLC · Arvada, COBuilt 1966 · S/N 18257649N244HEDubin David A · Tucson, AZS/N 21058990N244SPToth Douglas F · Scottsdale, AZBuilt 1963 · S/N 205-0379N2450LRobinson Brandon J · Winona Lake, INS/N 17255650N2450QSherry Mark A · Walla Walla, WABuilt 1966 · S/N 18257650N2450XBackcountry LLC · Ennis, MTBuilt 1965 · S/N 18256350N2451LSky K Inc · Wilmington, DES/N 17255651N2451QAviation Mission 3:16 LLC · White Lake, MIBuilt 1966 · S/N 18257651N2452QCallihan Richard L · Manning, SCBuilt 1966 · S/N 18257652N2452RKnutson Wayne R · Thompson, NDS/N 182-55552N2453QHarris Rand · Camas, WABuilt 1966 · S/N 18257653N2454LFulbright Steven R · Prineville, ORBuilt 1966 · S/N 17255654N2454QTracemont Flyers LLC · Boyce, LABuilt 1969 · S/N 15071341N2454RBrown Timothy L · Liberty Lake, WABuilt 1964 · S/N 18255554N2454XShiflett Tyrell · Deming, NMBuilt 1965 · S/N 18256354N2455QVan Diepen Thomas · Baker City, ORBuilt 1966 · S/N 18257655N2455RLaw John · Marina, CABuilt 1964 · S/N 18255555N2456R5625t LLC · Little Falls, NYBuilt 1964 · S/N 18255556N2456XBennett Annelise · Granbury, TXBuilt 1965 · S/N 18256356
Back to AD 72-03-03 R3