OpenAirDocs.org
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.

N29617Abbott Barry · Tempe, AZS/N 17700994N29619Loudenslager Donald F · Collinsville, OKBuilt 1968 · S/N 17700996N2961FNilssen Carl J · Cameron, WIBuilt 1966 · S/N 18257061N2961SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15066861N2961XLaurina Peter · Knoxville, TNBuilt 1967 · S/N 17700361N2961YGarcia Kale B · Covington, WABuilt 1962 · S/N 18253961N29625Sale Reported · Fort Myers, FLSale reportedBuilt 1968 · S/N 17700998N2962FMcclevey Landon Kole · Dilley, TXBuilt 1966 · S/N 18257062N2962XRomine John M · Broken Arrow, OKBuilt 1967 · S/N 17700362N2963FConnell Gary A · Anchorage, AKS/N 18257063N2963SDougherty Paul · Bethel, PABuilt 1967 · S/N 15066863N2963XWayner Ronald P · Sutton, AKBuilt 1967 · S/N 17700363N2963YMoretti Larry · Monroe, MIBuilt 1962 · S/N 18253963N29643Campbell Robert A · Dayton, TXS/N 17701005N29645Borgman Dale A · Rescue, CABuilt 1968 · S/N 17701006N2964FHunt Stuart J · Lynn Haven, FLBuilt 1966 · S/N 18257064N2964SRichardson David M · Dwight, ILBuilt 1967 · S/N 15066864N2964YVanderwel Paul · Woodinville, WABuilt 1962 · S/N 18253964N29651Geurs John Z · Ossian, INBuilt 1968 · S/N 17701009N2965FFrank Paul R · Waukesha, WIBuilt 1966 · S/N 18257065N2965XLynch Thomas L · Fort Collins, COBuilt 1967 · S/N 17700365N29667Viles Timothy · Bartlett, TNBuilt 1968 · S/N 17701016N2966FNansen Peter D · Bellingham, WABuilt 1966 · S/N 18257066N29673Olson Andrew S · Copper Canyon, TXBuilt 1968 · S/N 17701018N2967SJordan Jason A · Portland, MEBuilt 1967 · S/N 15066867N2968SVoyles Robert L · Seymour, TNBuilt 1967 · S/N 15066868N2968XJansen Edward M · Hummelstown, PABuilt 1967 · S/N 17700368N296BJQualitair LLC Trustee · MichelstadtBuilt 1965 · S/N 21058697N2970JFlorida State College At Jacksonville · Jacksonville, FLBuilt 1966 · S/N 15065770N2970SDouble Circle LLC · Bosque Farms, NMBuilt 1967 · S/N 15066870N2970XMonroe William R · Hawk Point, MOBuilt 1967 · S/N 17700370N2971FHaglund Jennifer J · Beaverton, ORBuilt 1966 · S/N 18257071N2972FPolus9 LLC · Houston, TXBuilt 1966 · S/N 18257072N2972JN2972j LLC · Nacogdoches, TXBuilt 1966 · S/N 15065772N2972SMaxwell Lance C · Saint Charles, ILBuilt 1967 · S/N 15066872N2973JHoyos Nicholas · Weston, FLBuilt 1966 · S/N 15065773N2974FCook Bentley · Sewanee, TNBuilt 1966 · S/N 18257074N2974ULeibach Frederick A · Peoria, ILBuilt 1965 · S/N 15062332N2975UDehay John M · Bynum, TXBuilt 1966 · S/N 17254180N2976FBates Joseph E · Providence, UTBuilt 1966 · S/N 18257076N2976JHanson Larry R · Buffalo, WYBuilt 1966 · S/N 15065776N2976SSapp Jarrell · Sale City, GAS/N 15066876N2976UReid Brian M · Boise, IDBuilt 1966 · S/N 17254525N2977FWhitesitt H Dean · Stevensville, MTBuilt 1966 · S/N 18257077N2977JBandy Suzanne M · Newport, ORS/N 15065777N2977YMccaw Edwin L · Ignacio, COBuilt 1962 · S/N 18253977N2978FNewman James Clayton · Tyler, TXBuilt 1966 · S/N 18257078N2978SRoach David · Modena, NYS/N 15066878N2979JStygar Richard M · Coal City, ILBuilt 1966 · S/N 15065779N297XWillwerth Lee J · Saline, MIBuilt 1967 · S/N 17700397
Back to AD 72-03-03 R3