OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,563

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.

N10617Kern Aviation LLC · Shafter, CABuilt 1973 · S/N 15074927N10618Roundy Kamlah F · Monteview, IDS/N 15074928N10621Brosh Cameron R · Loveland, COBuilt 1973 · S/N 15074930N10628Warner Daniel D · Linden, MIBuilt 1973 · S/N 15074932N10630Perez Juan Carlos · Miami Gardens, FLS/N 15074934N10644American Flag Airlines Inc · Ft Lauderdale, FLBuilt 1973 · S/N 15074942N10645Dearborn Edward M · Acworth, GAS/N 15074943N10647Kosko Stanley G · Seattle, WAS/N 15074945N10649Seaplane Adventures LLC · Cheyenne, WYS/N 15074947N10651Wampler Matthew T · Valles Mines, MOBuilt 1973 · S/N 15074948N10653Loftin Jamie B · Shreveport, LABuilt 1973 · S/N 15074950N10658Craigmyle William R · Cooperstown, NYBuilt 1973 · S/N 15074952N10661Colberg Sigurd E · Palmer, AKBuilt 1973 · S/N 15074955N10663General Aircraft Services LLC · Pendleton, ORS/N 15074957N10669Loeppky Neal K · Seminole, TXBuilt 1973 · S/N 15074962N10679Samson Rene R · Lewiston, MES/N 15074968N1067LCollins Gene William · Manassas, VABuilt 1973 · S/N 15074965N10681Chickasha Wings Inc · Chickasha, OKBuilt 1973 · S/N 15074970N10682Thomas Edward L · West Bend, WIBuilt 1973 · S/N 15074971N10683Burton Ryne W · Astoria, ILBuilt 1973 · S/N 15074972N10687Boatright William L · Colonial Beach, VABuilt 1973 · S/N 15074974N10688Wilson Oscar O Jr · Kountze, TXBuilt 1973 · S/N 15074975N10689Jansen Sarah · Pingree Grove, ILBuilt 1973 · S/N 15074976N10693Full Stop Aviation LLC · Union City, TNBuilt 1973 · S/N 15074978N106UCInsuraclaim LLC · Boca Raton, FLBuilt 1981 · S/N 15285419N10732Hale Sidney B · Bonham, TXBuilt 1973 · S/N 15074990N10737Shelley Matthew A · Cleveland, NCBuilt 1973 · S/N 15074994N10738Lindsay Tyler R · Kimberly, IDBuilt 1973 · S/N 15074995N10741Rice Zachary N · Los Angeles, CABuilt 1973 · S/N 15074998N10742Lewis Thomas R · Aransas Pass, TXBuilt 1973 · S/N 15074999N10747Smith James E · Port Charlotte, FLS/N 15075003N10748Jensen David · Bronte, TXBuilt 1973 · S/N 15075004N10749Atg Capital Management LLC · New York, NYS/N 15075005N10750Pomeroy Andrew B · North Berwick, MEBuilt 1973 · S/N 15075006N10752Planesmen Aviation LLC · Grant, NEBuilt 1973 · S/N 15075007N10754Morris Adam R · Stuttgart, ARS/N 15075008N10758Round Engine Aero · Nashville, MIS/N 15075012N10762Blaisdell Leo F · Kalkaska, MIS/N 15075016N10763Cromley Orvis H · Lewisburg, PAS/N 15075017N10766Aurora 17 Holdings LLC · Aurora, ORBuilt 1973 · S/N 15075020N10773Cole Clayton R · Cottonwood, CABuilt 1973 · S/N 15075026N10774Crawford Carolyn Marina · Kenai, AKBuilt 1973 · S/N 15075027N10777Scott Randolph J DBA · New Orleans, LABuilt 1973 · S/N 15075030N10784Woods James D · Carthage, TXS/N 15075036N10793Jarvis Laura A · Cornwall, VTBuilt 1973 · S/N 15075044N10808Carter Curtiss D · Orono, MES/N 15075052N10815Oklahoma Flight Academy LLC · Owasso, OKBuilt 1973 · S/N 15075058N10820Wojteczko Jason A · Derby, KSBuilt 1973 · S/N 15075062N10829Brekhus Clifford G Trustee · Minot, NDBuilt 1973 · S/N 15075069N10830Fundamentals Aircraft Leasing LLC · Erie, PABuilt 1973 · S/N 15075070
Back to AD 2009-10-09 R2