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.

N8181SCopeland Kevin D · Vidalia, GABuilt 1965 · S/N 15061781N8181UMillman Chris · Auburn, WABuilt 1964 · S/N 17252081N8182UMorristown Flying Service Inc · Talbott, TNBuilt 1964 · S/N 17252082N8182ZWolf Richard Cory · Syracuse, UTBuilt 1963 · S/N 2050182N8183FArvizu Jason Arthur Scott · Bakersfield, CABuilt 1966 · S/N 15064283N8183UMacauley Richard D · Shingle Springs, CABuilt 1964 · S/N 17252083N8184LVanderlaan Dirk C · Reno, NVBuilt 1967 · S/N 17256384N8185SJanssen Christopher M · Manchester, IABuilt 1965 · S/N 15061785N8185ZViele Mark C · Buckley, WABuilt 1963 · S/N 205-0185N8186LBolsover Douglas J Sr · Cameron Park, CAS/N 17256386N8186ULake Area Technical College · Watertown, SDBuilt 1964 · S/N 17252086N8186ZBernard David John · Damascus, MDBuilt 1963 · S/N 205-0186N8187FCoady Michael J · Taylorville, ILBuilt 1966 · S/N 15064287N8187SCounter Kevin · Windsor, CAS/N 15061787N8188ZHzl Hanger LLC · Drums, PABuilt 1963 · S/N 205-0188N8189FArchuleta Michelle L · Las Cruces, NMBuilt 1973 · S/N A1500455N8189ZMirage Mfg Co Inc · Gainesville, FLBuilt 1962 · S/N 205-0189N818MLTurning Point Northwest LLC · Stanwood, WABuilt 1966 · S/N 15064017N8190LOlsen Curtis O · Lindon, UTS/N 17256390N8191FMoore Clayton P · Cayce, SCBuilt 1966 · S/N 15064291N8191SStang Daniel Jr · Lindale, TXBuilt 1965 · S/N 15061791N8191UAnderson Amy J · Manistique, MIBuilt 1964 · S/N 17252091N8192LSteinmetz William · Lakeville, INBuilt 1967 · S/N 17256392N8192UMichael Isiah · Jersey City, NJBuilt 1964 · S/N 17252092N8193FMother Lode Flying Club · San Andreas, CABuilt 1966 · S/N 15064293N8193LDavis Timothy A · Oklahoma City, OKBuilt 1967 · S/N 17256393N8193SVoshell Frank T · Freeport, MIBuilt 1965 · S/N 15061793N8194UHutson Clayton · Elgin, OKBuilt 1964 · S/N 17252094N8195SMolina Manolo R · Fayetteville, ARBuilt 1965 · S/N 15061795N81963Larson Wayne M · Plymouth, MNBuilt 1966 · S/N 15063608N8196LMoore Nick C · Adamsville, TNBuilt 1967 · S/N 17256396N8196ZMahaney James G · Tahlequah, OKBuilt 1963 · S/N 205-0196N8197FHartman Eric J · Wilson, NYBuilt 1966 · S/N 15064297N8198FDesterfans Lance · Lodi, CAS/N 15064298N8198RUsda Forest Service Fepp · Malvern, ARS/N R1720158N8198SHhd Aviation LLC · Hamilton, OHS/N 15061798N8198UTower Christopher M · Piedmont, OKBuilt 1964 · S/N 17252098N8199UReeder James T · Ottawa, KSS/N 17252099N8199ZParker Wesley A · Cookeville, TNBuilt 1963 · S/N 205-0199N819EBWalker Kyle V · Bastrop, TXBuilt 1966 · S/N 15063984N81CMBrothers Holdings LLC · Waterford, MIBuilt 1971 · S/N 18260721N81HDSkytte Christian · Wichita, KSBuilt 1963 · S/N 18254900N81LWCloud Seven LLC · Fort Pierce, FLBuilt 1976 · S/N 17702455N81RPLull William G · Ramona, CABuilt 1971 · S/N 177RG0170N81SCGl Aircraft Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 21059382N81TJHelgerson Nicky A · Zwingle, IABuilt 1964 · S/N 18255385N8200FCallanan Craig E · Stillwater, NJBuilt 1966 · S/N 15064300N8200GRj Vincent Enterprises LLC · Rancho Santa Fe, CABuilt 1971 · S/N 177RG0100N8200SPoms Maxfield David · Groveland, CABuilt 1965 · S/N 15061800N8201FYellott Jerry L Jr · Dequincy, LABuilt 1966 · S/N 15064301
Back to AD 72-03-03 R3