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.

N2918JNiemann Benjamin W · Welton, IAS/N 15065718N2918SAbove All Aviation Inc · Goleta, CABuilt 1967 · S/N 15066818N2919SJust Plane Corp · Kokomo, INS/N 15066819N2920JRegistration Pending · Powell Butte, ORRegistration pendingBuilt 1966 · S/N 15065720N2920SLea Nathanael E · Olalla, WABuilt 1967 · S/N 15066820N2920VMorrow William M Jr · Harrison, IDBuilt 1974 · S/N 15076320N2921JAndrews University · Berrien Springs, MIBuilt 1966 · S/N 15065721N2922JStecklein Brittney R · Overland Park, KSBuilt 1966 · S/N 15065722N2922SWard Aviation · Marysville, OHBuilt 1967 · S/N 15066822N2923SHamann John · Orlando, FLBuilt 1967 · S/N 15066823N2924JPiscoya Thomas G · Anchorage, AKBuilt 1966 · S/N 15065724N2925SSmolik Amanda · Ponder, TXBuilt 1967 · S/N 15066825N2926SFord John M · Rock Stream, NYS/N 15066826N2926WSessoms Keith V · Seagrove, NCS/N 15284388N2928JVu Huy T · San Diego, CABuilt 1966 · S/N 15065728N2928SDoubler Endeavors LLC · Orlando, FLBuilt 1967 · S/N 15066828N2929STerrell Aviation Inc · Terrell, TXS/N 15066829N2930JTetil Nicholas M · Fairgrove, MIBuilt 1966 · S/N 15065730N2931JSmith William T · Fort Payne, ALBuilt 1966 · S/N 15065731N2932SRutoski Mary Ann · Jordan, MNBuilt 1967 · S/N 15066832N2933SHarry Kevin M · Salisbury, NCBuilt 1967 · S/N 15066833N2935JSmith Stanley P · Athens, ALBuilt 1966 · S/N 15065735N2936JElkins James D · Salem, ORBuilt 1966 · S/N 15065736N2936VMurphy Julian Ryan · Knoxville, TNBuilt 1974 · S/N 15076327N2937JSchumann Jennifer Pauline · Conroe, TXBuilt 1966 · S/N 15065737N2941JReilly Isabella · Prescott, AZBuilt 1966 · S/N 15065741N2942JRegistered aircraftBuilt 1966 · S/N 15065742N2942SEvenson Don C · Moorhead, MNS/N 15066842N2944JThomas Edward R · Piney Flats, TNS/N 15065744N2944SChartrand Robert J · Brimley, MIBuilt 1967 · S/N 15066844N2945VMcclellan Stephanie · Hebron, ILS/N 15076330N2946SFreed Michael · Sylmar, CABuilt 1967 · S/N 15066846N2947JMaggio Anthony M · Harbor City, CABuilt 1966 · S/N 15065747N2948JSale Reported · Ruston, LASale reportedBuilt 1966 · S/N 15065748N2949SRegistered aircraftBuilt 1967 · S/N 15066849N2950JRunway Aviation Flight Training USA Corp · Rockwall, TXS/N 15065750N2950SJohnson Aviation LLC · Middleton, IDS/N 15066850N2950VCollins Robert J · Kennett Square, PABuilt 1974 · S/N 15076332N2951JJohnston Robert G · Rose Hill, KSBuilt 1966 · S/N 15065751N2953SKelley Mark · El Granada, CABuilt 1967 · S/N 15066853N2955JAguilar Honorio Alejandro · Anna, TXBuilt 1966 · S/N 15065755N2956JDecker Kathy A · Greenville, MIBuilt 1966 · S/N 15065756N2956SPuder Karen D · Lenzburg, ILBuilt 1967 · S/N 15066856N2957JMcmahon Thomas G · Hoffman Estates, ILBuilt 1966 · S/N 15065757N2959JJones Eugene B Jr · Pflugerville, TXBuilt 1966 · S/N 15065759N2959SCobb Patricia J Trustee · North Las Vegas, NVS/N 15066859N295THHowser Anthony J · Batavia, OHS/N 15072736N2960JGlinsky Edward Jr · Rhome, TXBuilt 1966 · S/N 15065760N2960SDewitt Daniel · Camarillo, CABuilt 1967 · S/N 15066860N2961SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15066861
Back to AD 2009-10-09 R2