OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,565

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:2009-10-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-10-09-R2')
  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.

N8305MGossage Terrence L · Port Angeles, WABuilt 1969 · S/N A1500005N8306GLees Michael S · Port Allen, LABuilt 1965 · S/N 15062406N8307GRegistered aircraftS/N 15062407N8308GThompson Stephen A · Murphy, NCBuilt 1965 · S/N 15062408N8309GWoods Allen D · Old Hickory, TNBuilt 1965 · S/N 15062409N830JDMarlin David D · Conway, MOS/N 15068819N830WHJorgensen Robert M · Tracy, CABuilt 1975 · S/N 15076730N8310JWerth Thomas A · Seattle, WABuilt 1967 · S/N 15066210N8310MFlying Engineers Inc · Indianapolis, INBuilt 1969 · S/N A1500010N8311GLockwood William E · Carmel, NYS/N 15062411N8311JD T Flying Inc · Okeene, OKBuilt 1967 · S/N 15066211N8312GYampolskiy Dmitriy · San Pedro, CABuilt 1965 · S/N 15062412N8313USchmidt Jeffrey L · Granbury, TXS/N 15077918N8314MDavid Ari C Esq Trustee · San Diego, CABuilt 1969 · S/N A1500014N8315GNaisby Walter H · Harvey Cedars, NJBuilt 1965 · S/N 15062415N8317JHinojosa Edward · Georgetown, TXBuilt 1967 · S/N 15066217N8318JGreat Lakes Air Ventures LLC · Mason, MIBuilt 1967 · S/N 15066218N8321GSilveria Clifford J · Humble, TXBuilt 1965 · S/N 15062421N8322JMiller Patrick · Riverside, CABuilt 1967 · S/N 15066222N8323GRusso Dobye G · Clinton, OKBuilt 1965 · S/N 15062423N8323JKc Eagles Soaring Club · Gardner, KSBuilt 1967 · S/N 15066223N8323MBean Danny O · Mulkeytown, ILBuilt 1969 · S/N A1500023N8324GDexter Brady R · Chambers, NES/N 15062424N8324MKnox John D · Broken Arrow, OKBuilt 1969 · S/N A1500024N8326UHill John R · Seattle, WABuilt 1976 · S/N 15077920N8327JSaunders Grant J · Sebring, FLBuilt 1967 · S/N 15066227N8327MArch Frederick W Jr · Lake Placid, FLBuilt 1969 · S/N A1500027N8328JTreat James · Batesville, ARBuilt 1967 · S/N 15066228N8328MLuker Victor R Jr · Terrell, TXS/N A15000028N8329JWooley Eva · Hephzibah, GABuilt 1967 · S/N 15066229N832SRWallace John M · Canton, MSS/N 15062860N8331GWhitley Jonathan K · Goldsboro, NCBuilt 1965 · S/N 15062431N8332GFlack Kevin S · Woolford, MDBuilt 1965 · S/N 15062432N8333GInvestair LLC · Conway, ARBuilt 1965 · S/N 15062433N8334GAvcraft Inc · Columbus, NEFirst renewal noticeBuilt 1965 · S/N 15062434N8336JGoat Rodeo Aviation LLC · Leesburg, INBuilt 1967 · S/N 15066236N8336MStarz Align Aviation LLC · Marshfield, WIBuilt 1969 · S/N A1500036N8337GSkyline Aviation Inc · San Angelo, TXBuilt 1965 · S/N 15062437N8337JGeorge Downer Flyers LLC · Aliceville, ALS/N 15066237N8340MBlake Larry Q · Suwanee, GABuilt 1969 · S/N A1500040N8341MKab Aviation LLC · Cassopolis, MIBuilt 1969 · S/N A1500041N8342MStreeter Wyatt E · Hanford, CABuilt 1969 · S/N A1500042N8343MDuke Kay L · Darrouzett, TXBuilt 1969 · S/N A1500043N8344GDonat Brandon L · Glendale, AZS/N 15062444N8345MBryant William G · Kenai, AKS/N A1500045N8346GN8346g LLC · Fort Pierce, FLBuilt 1965 · S/N 15062446N8346JHodgman Robert J · Yakima, WABuilt 1967 · S/N 15066246N8347GKeyes Mitchell R · Cornelius, NCBuilt 1965 · S/N 15062447N8349MMarker Nathan E · Amherst, OHBuilt 1969 · S/N A1500049N834GTIlmberger Stephen R · Sisters, ORBuilt 1981 · S/N 15285111
Back to AD 2009-10-09 R2