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.

N436SAClark Vernon · Olalla, WABuilt 1967 · S/N 15067549N4411Mh Aviation LLC · Dublin, CABuilt 1965 · S/N 15062560N4420ENoguerra Eric · Astoria, ORBuilt 1973 · S/N 15073879N4441KWeaver Aircraft Co · Carson City, NVBuilt 1966 · S/N 15065397N4444VWolfe Randy K · Middle Grove, NYBuilt 1971 · S/N 15072907N444GSWhitten Andrew J · Astoria, ORBuilt 1975 · S/N 15077446N444TR444 Tr Inc · Van Alstyne, TXBuilt 1967 · S/N 15067661N4468QStephney Zaccheus K · Douglasville, GABuilt 1981 · S/N 15284723N447DKDecesare Lynnette · Charlotte, NCBuilt 1974 · S/N 15076128N44WBEvans Jerry R · York, PABuilt 1980 · S/N A1520909N45023New Joel · Waco, TXBuilt 1975 · S/N 15076705N45028Witke Ray · Menomonie, WIBuilt 1975 · S/N 15076706N45031Stahla Russell · Girdwood, AKBuilt 1975 · S/N 15076709N45034Coffelt Roy · Nampa, IDBuilt 1975 · S/N 15076710N45045Lingle Gordon D · Gun Barrel City, TXBuilt 1975 · S/N 15076711N45058Red Cardinal Aviation LLC · Chantilly, VAS/N 15076715N45073Trailing Edge LLC · Elmira, NYBuilt 1975 · S/N 15076724N45080Todd Doug A · Dewitt, IABuilt 1975 · S/N 15076726N45082Long Robert D · Kinston, NCBuilt 1975 · S/N 15076727N45112Iaba LLC · Norfolk, VABuilt 1975 · S/N 15076739N45115Jiang Jun · Fremont, CAS/N 15076740N45132Jamesweathers Robi J · Blaine, MNS/N 15076747N45143Fly Sky Ads LLC · Manalapan, NJBuilt 1975 · S/N 15076753N45156Flight Training Solutions LLC · Longwood, FLBuilt 1975 · S/N 15076760N45166Jet Life LLC · Coconut Creek, FLS/N 15076764N45169Carlisle Elizabeth L · Mohnton, PABuilt 1975 · S/N 15076766N45170Smits Joel R · Crete, ILBuilt 1975 · S/N 15076767N45190Violette Colin E · Rough And Ready, CABuilt 1975 · S/N 15076777N45198Ebe Aviation LLC · Urbandale, IABuilt 1975 · S/N 15076781N45203November 45203 LLC · Waterbury Center, VTBuilt 1975 · S/N 15076784N45230Zutter Regan James · Hooper, UTBuilt 1975 · S/N 15076793N45235Grimes James R · Carlton, GAS/N 15076796N45237Defrees Brooks H · Boulder, COBuilt 1975 · S/N 15076797N45243Keas Kirby Clay · Lakeway, TXS/N 15076800N45245Rimar Dale S · Boca Raton, FLS/N 15076802N45246Carlsen Brent R · Rochester, MNBuilt 1975 · S/N 15076803N45247Airgo Inc · Centralia, ILBuilt 1975 · S/N 15076804N45256Albertson James M · Westville, FLBuilt 1975 · S/N 15076808N45262Wyoming Aviation Association Inc · Cheyenne, WYBuilt 1975 · S/N 15076811N45263Ruder Bonita E · Maple Park, ILBuilt 1975 · S/N 15076812N45270Lessley Gavin W · Carrollton, MSBuilt 1975 · S/N 15076815N45274Robinson Charles F · Portage, MIFirst renewal noticeBuilt 1975 · S/N 15076817N45281Stewart Patrick D · Reading, MIBuilt 1975 · S/N 15076822N45284Kelley Keith B · Forney, TXBuilt 1975 · S/N 15076823N45285Bennett Aaron K · Pulaski, VAS/N 15076824N45302Missinne Brett R · South Range, WIBuilt 1975 · S/N 15076832N45308Berry Thomas F · Emmett, IDBuilt 1975 · S/N 15076833N45327Cullen Richard J · Oshkosh, WIS/N 15076845N45328N45328 LLC · Naples, FLS/N 15076846N45335Keeney Daphne C · Fairbanks, AKBuilt 1975 · S/N 15076852
Back to AD 2009-10-09 R2