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.

N3168VAirgo Inc · Cetralia, ILBuilt 1974 · S/N 15076407N3169XVirgilio Domenico · Rochester Hills, MIBuilt 1966 · S/N 15064569N316PCRegistration Pending · Payson, AZRegistration pendingBuilt 1968 · S/N 15069440N3170JDobrzynski Andrzej J · Chicago, ILBuilt 1966 · S/N 15065870N3170XFlying L Aircraft Inc · Fort Denaud, FLBuilt 1966 · S/N 15064570N3171JRay Charles B · Prosser, WAS/N 15065871N3171XJohnson Christopher A · San Diego, CABuilt 1966 · S/N 15064571N3172FKuhn Joseph C · Manhattan Beach, CABuilt 1973 · S/N A1500407N3173XRegistration Pending · Lutz, FLRegistration pendingBuilt 1966 · S/N 15064573N3174XRenner Colton A · Easley, SCBuilt 1966 · S/N 15064574N3175JJohnson David J Jr · Yucaipa, CABuilt 1966 · S/N 15065875N3175VDunaire LLC · Mechanicsburg, PABuilt 1974 · S/N 15076408N3176JAquaero LLC · San Antonio, TXBuilt 1966 · S/N 15065876N3176XHarless Phillip M · Mcdonough, GAFirst renewal noticeBuilt 1966 · S/N 15064576N3177JDouble Rr Holdings LLC · Dallas, TXS/N 15065877N3177VSmith Daniel P · St George, UTBuilt 1974 · S/N 15076409N3177XBandy Suzanne M · Newport, ORBuilt 1966 · S/N 15064577N3178JBirmingham Pilot Academy LLC · Birmingham, ALS/N 15065878N3179JTri-County Flyers LLC · Morgantown, PABuilt 1966 · S/N 15065879N3181XHart George · Roseville, CABuilt 1966 · S/N 15064581N3182XHerrera Lizann · Sumner, WABuilt 1966 · S/N 15064582N3183JRank Brian Andrew · Oxford, MIBuilt 1966 · S/N 15065883N3183XTrimble John Sr · Stone Mountain, GABuilt 1966 · S/N 15064583N3184XSandlapper Aviation Of De · Bennington, VTBuilt 1966 · S/N 15064584N3185XSanders John L · Sikeston, MOS/N 15064585N3186JHowenstein John G · Roseville, CABuilt 1966 · S/N 15065886N3186XPanus Mark V · Hinsdale, NYBuilt 1966 · S/N 15064586N3187JBrar Amuldeep S · Austin, TXBuilt 1966 · S/N 15065887N3188JFlight Time Builders Inc · Memphis, TNBuilt 1966 · S/N 15065888N3189VMunn Julian · Spring, TXS/N 15076413N3190JSimon Mitchell B · Edison, NJBuilt 1966 · S/N 15065890N3190XOso Air LLC · Missoula, MTBuilt 1966 · S/N 15064590N3191JPhillips Nicholas H · Mikana, WIS/N 15065891N3192JWestern Altitude LLC · Dayton, MTBuilt 1966 · S/N 15065892N3193JWebs James H · Alexander, KSFirst renewal noticeBuilt 1966 · S/N 15065893N3193VFly Sky Ads LLC · Manalapan, NJBuilt 1974 · S/N 15076414N3196XFroes Carlos Da Lapa · Avondale, AZS/N 15064596N3197XLynn Christopher M · Hood River, ORBuilt 1966 · S/N 15064597N3198JAlternate Air Inc · Seattle, WABuilt 1966 · S/N 15065898N3199XClark Terry E · Dixon, MOBuilt 1966 · S/N 15064599N319DDenimarck Vincent · Wildwood, FLBuilt 1969 · S/N 15070159N3200JOdell Steven P · Perrysburg, OHBuilt 1966 · S/N 15065900N3201XSale Reported · Glen Allen, VASale reportedBuilt 1966 · S/N 15064601N3204JBecker Charles A · Rice Lake, WIBuilt 1966 · S/N 15065904N3204XKulesza Roman · Noblesville, INBuilt 1967 · S/N 15064604N3205XAvery Jackson R · Ontario, ORS/N 15064605N3208JLandon Christopher L · Portland, ORBuilt 1966 · S/N 15065908N3208XRhodenbaugh Mitchel D · Wyndmere, NDBuilt 1966 · S/N 15064608N3211JGo Captain LLC · Lake Worth, FLBuilt 1966 · S/N 15065911N3212JBrown Joseph E · Palmdale, CABuilt 1966 · S/N 15065912
Back to AD 2009-10-09 R2