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.

N82ADAdams Aircraft LLC · Wilmington, DEBuilt 1961 · S/N 18253753N82BGGrimshaw Brian Trustee · Long Beach, CABuilt 1964 · S/N 18255427N82CTCoelho Gabriel P · Chowchilla, CABuilt 1969 · S/N 18259804N82EDRodriguez Rolando · Harlingen, TXBuilt 1973 · S/N 15075663N82HABeller Ronald D · Morehead, KYBuilt 1976 · S/N 17702401N82HSAdventist World Aviation · Wilson, NCBuilt 1971 · S/N 18260814N82SLHanus Logan D · Kenyon, MNS/N 18257976N8300UFrisby Richard V · Fredericksburg, VABuilt 1964 · S/N 17252200N8301UN8301u LLC · White Springs, FLBuilt 1964 · S/N 17252201N8302GLittle Air Dream LLC · Mooresville, NCBuilt 1965 · S/N 15062402N8302ZAbbott Barry · Tempe, AZBuilt 1963 · S/N 205-0302N8303JFodero Jesse G · West Seneca, NYBuilt 1967 · S/N 15066203N8303SSamia Robert B · The Plains, VABuilt 1965 · S/N 18256403N8304ZBin Parts Inc · Fargo, NDS/N 205-0304N8305MGossage Terrence L · Port Angeles, WABuilt 1969 · S/N A1500005N8305SHatley Ralph A · Eagle Creek, ORBuilt 1965 · S/N 18256405N8305USkyhawk Leasing LLC · Port Huron, MIBuilt 1964 · S/N 17252205N8305ZAlpha Cloud LLC · Lake Wylie, SCBuilt 1963 · S/N 205-0305N8306GLees Michael S · Port Allen, LABuilt 1965 · S/N 15062406N8307GRegistered aircraftS/N 15062407N8307SKohlitz Jeffery P · Harrison Township, MIBuilt 1965 · S/N 18256407N8308GThompson Stephen A · Murphy, NCBuilt 1965 · S/N 15062408N8308SThun John C · Concrete, WABuilt 1965 · S/N 18256408N8309GWoods Allen D · Old Hickory, TNBuilt 1965 · S/N 15062409N8309ZCypress Church Farms LLC · Greenwood, SCBuilt 1963 · S/N 2050309N830JDMarlin David D · Conway, MOS/N 15068819N830WDurakovich David A · Coshocton, OHBuilt 1963 · S/N 18254945N8310JWerth Thomas A · Seattle, WABuilt 1967 · S/N 15066210N8310MFlying Engineers Inc · Indianapolis, INBuilt 1969 · S/N A1500010N8310SBabovic Slobodan · Elm Grove, WIBuilt 1965 · S/N 18256410N8310UUnderwood Michael D II · Piney Flats, TNS/N 17252210N8310ZEkstrom Benjamin G · Anchorage, AKBuilt 1963 · S/N 205-0310N8311GLockwood William E · Carmel, NYS/N 15062411N8311JD T Flying Inc · Okeene, OKBuilt 1967 · S/N 15066211N8311UVendetta Consulting LLC · Bellevue, NEBuilt 1964 · S/N 17252211N8312GYampolskiy Dmitriy · San Pedro, CABuilt 1965 · S/N 15062412N8312SSky Aviation Holdings LLC · Pompano Beach, FLBuilt 1965 · S/N 18256412N8312URowe John R · Stevens Point, WIBuilt 1964 · S/N 17252212N8314MDavid Ari C Esq Trustee · San Diego, CABuilt 1969 · S/N A1500014N8314USchmidt Roger W · Wood River, NEBuilt 1964 · S/N 17252214N8315GNaisby Walter H · Harvey Cedars, NJBuilt 1965 · S/N 15062415N8316LCorletto Carlos · Bermuda Dunes, CABuilt 1968 · S/N 17256516N8316ZBlackwing Aviation LLC · Corona, CAS/N 205-0316N8317JHinojosa Edward · Georgetown, TXBuilt 1967 · S/N 15066217N8317LWalker Paul R · Ursa, ILBuilt 1968 · S/N 17256517N8317URiver International LLC · Orlando, FLS/N 17252217N8317ZShupe David · Dayton, NVBuilt 1963 · S/N 205-0317N8318JGreat Lakes Air Ventures LLC · Mason, MIBuilt 1967 · S/N 15066218N8318UBeattie Steven K · Colville, WABuilt 1964 · S/N 17252218N8319LLaudon Piper C · Anchorage, AKS/N 17256519
Back to AD 72-03-03 R3