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.

N346BJDixon Craig S · Rimrock, AZBuilt 1967 · S/N 15066160N3470JEdson Vincent · Auburn, CAS/N 15066170N3471JLogtime Flight LLC · Lancaster, TXBuilt 1967 · S/N 15066171N3475VSatterlee Michael E · Clever, MOBuilt 1974 · S/N 15076513N3476JJr Imaging Logistics Inc · Pasco, WAS/N 15066176N3478VGazsy William · North Bellmore, NYS/N 15076514N3482JShelton David R · Potter Valley, CABuilt 1967 · S/N 15066182N3486VLiberty Aviation LLC · Henderson, NVBuilt 1974 · S/N 15076518N3489VMathews Richard III · Cuthbert, GABuilt 1974 · S/N 15076519N3491JNightknight LLC · Palm Bay, FLS/N 15066191N3495JWatson John T Jr · Fairfield, CABuilt 1967 · S/N 15066195N3495VSignal Air Service Inc · Gallatin Gateway, MTBuilt 1974 · S/N 15076523N3496VRasch James L · Conklin, MIBuilt 1974 · S/N 15076524N3498JThompson Rick L · Chico, CABuilt 1967 · S/N 15066198N34APPitman Amanda R · Harrah, OKBuilt 1975 · S/N 15076814N34GMinerva Keith R · Jacksonville, FLS/N 15061615N34TDHartwig Samuel H · Neelyville, MOBuilt 1971 · S/N 15073100N34TKWilkinson Paul R · Colonial Beach, VABuilt 1969 · S/N 15070364N3500LDragonfly Aviation LLC · Winder, GABuilt 1965 · S/N 15062300N3503VMock Joseph R · Huntsville, TXBuilt 1974 · S/N 15076526N3505LPilot Training Northwest LLC · Sandpoint, IDBuilt 1965 · S/N 15062305N3507VBrock Aviation Flight School LLC · Douglasville, GABuilt 1974 · S/N 15076528N3509LNortheastern Oregon Flying Club · La Grande, ORBuilt 1965 · S/N 15062309N350SQGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285152N3513VHaussler Stephen K · Arlington Heights, ILS/N 15076530N3517FCebelak William G · Kent City, MIBuilt 1973 · S/N A1500410N3519VVanderpool Kenneth J · Portsmouth, NHBuilt 1974 · S/N 15076533N3520LGregory Austin · Bothell, WABuilt 1965 · S/N 15062320N3521LBiorn Howard L · Brooklyn Center, MNS/N 15062321N3522LTyler Clark D · Fort Wayne, INS/N 15062322N3526LLewis Clinton A · Antlers, OKS/N 15062326N3527LAiken Clifford M Jr · Loganville, GABuilt 1965 · S/N 15062327N3528LTioga Land Development LLC · Tioga, NDS/N 15062328N352JRegistration Pending · Coconut Creek, FLRegistration pendingBuilt 1974 · S/N 15075742N352WAC & M Aviation LLC · Lawrence, KSS/N 15282909N3531LLihs Austin R · Sioux City, IAS/N 15062331N3534VJervis Joseph · Genoa, WVS/N 15076537N3535LToy Donald R · Homestead, IABuilt 1965 · S/N 15062335N3536LPnw Sky Trekking LLC · Colville, WABuilt 1965 · S/N 15062336N3539LCummings Kenneth · Camano Island, WABuilt 1965 · S/N 15062339N353JKAirspeed Marketing LLC · Phoenix, AZS/N 15076910N353WFlight Path Ra LLC · North Miami, FLS/N 15078799N3540VPearson Victor E · Lake Stevens, WABuilt 1975 · S/N 15076539N3543LPeaster David · Brunswick, GABuilt 1965 · S/N 15062343N3545VSoaring Pinions LLC · Rittman, OHBuilt 1975 · S/N 15076541N3553LDulce Vida Property Consultants LLC · Denver, NCBuilt 1965 · S/N 15062353N3554VHayes Kenneth L · Blue Ridge, VABuilt 1975 · S/N 15076545N3556LBurrows Brian A · Argyle, TXS/N 15062356N3557LStauffer Tom · Renton, WABuilt 1965 · S/N 15062357N355AAAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N 15284224
Back to AD 2009-10-09 R2