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.

N774MDecker Royce B · Deridder, LABuilt 1977 · S/N 15079345N7752FBoulware James Curtis · New Smyrna Beach, FLBuilt 1966 · S/N 15063852N7755FHayhurst Shane R · Winfield, PAFirst renewal noticeBuilt 1966 · S/N 15063855N7756GDedalis Emory A · Colts Neck, NJBuilt 1973 · S/N 15074725N7756UReid Wayne P Jr · Yucaipa, CAS/N 15077832N7761FSullivan Randall G · Liberty, TXBuilt 1966 · S/N 15063861N7762FCosta Air Service LLC · Painted Post, NYS/N 15063862N7763FRoss Joshua S · Homer, AKBuilt 1966 · S/N 15063863N7763UMarshall Michael S · Lincoln, CABuilt 1976 · S/N 15077835N7764FAbouhatab Majed · Houston, TXBuilt 1966 · S/N 15063864N7765FFilippone Chrristopher A · Ormond Beach, FLS/N 15063865N7765UCentral Ohio Soaring Association Inc · Marion, OHBuilt 1976 · S/N 15077837N7766FBuckman Bill · Lorenzo, TXBuilt 1966 · S/N 15063866N7767FMorris Donald R · Murphysboro, ILS/N 15063867N7767USkynet Aviation LLC · Cocoa Beach, FLS/N 15077838N7768UFoothill Sport Aviation LLC · Cameron Park, CABuilt 1976 · S/N 15077839N776SASopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1976 · S/N 15077884N7772FCushing Aviation LLC · Red Wing, MNBuilt 1966 · S/N 15063872N7773FDux Aaron T · Missoula, MTS/N 15063873N7774FMurphy Jeffrey R · Newport, MNS/N 15063874N7779FSmith Brian · Richmond, INBuilt 1966 · S/N 15063879N7780FDuquette Stephen R · Fenton, MIS/N 15063880N7782FLewis Wayne · Martin, TNBuilt 1966 · S/N 15063882N7783FMiller Patrick G · Homer, AKBuilt 1966 · S/N 15063883N7784FSelf Edwin C · Columbia, TNBuilt 1966 · S/N 15063884N7788FGerig David J · Woodburn, INBuilt 1966 · S/N 15063888N7789FSutton George R · Big Bear City, CABuilt 1966 · S/N 15063889N7792FBas Part Sales LLC · Greeley, COS/N 15063892N7794FWhitman Larry C · Hinesville, GABuilt 1966 · S/N 15063894N7794UFlying Colors Airparts Inc · Leesburg, FLBuilt 1976 · S/N 15077843N7796FLucarelli David L · Moncks Corner, SCBuilt 1966 · S/N 15063896N7796UDemaagd Ross E · Middleville, MIBuilt 1976 · S/N 15077844N7797UHutchison Ryan A · Etiwanda, CABuilt 1976 · S/N 15077845N7799FGeese Douglas A · Churubusco, INBuilt 1966 · S/N 15063899N77PPBloom Jonah M · Palmer, AKBuilt 1972 · S/N 15073293N7800FS & L Aviation LLC · Ashland, OHS/N 15063900N7801UDeli Rick L · Oshkosh, WIS/N 15077846N7806FTaheri Jay · Ridgewood, NJBuilt 1966 · S/N 15063906N7807FFletcher Edwin R Jr · Flowery Branch, GAFirst renewal noticeBuilt 1966 · S/N 15063907N7813FUp And Away Aviation LLC · Poughkeepsie, NYBuilt 1966 · S/N 15063913N7814GClayton Steve · San Anotonio, TXBuilt 1973 · S/N 15074730N7819ULott Tyler · Kenneth City, FLBuilt 1976 · S/N 15077849N7821FKoch Leasing LLC · Campbellsville, KYBuilt 1966 · S/N 15063921N7823FJackson Larry T · Maplesville, ALS/N 15063923N7827GFlying Falkor LLC · Bellevue, WAS/N 15074732N7828FTaylor Andrew G · Lexington, KYBuilt 1966 · S/N 15063928N7831FHallmark Ryan M · Vidor, TXBuilt 1966 · S/N 15063931N7837FObrien Daniel N Jr · Bellevue, WABuilt 1973 · S/N A1500450N7838FMcdonald Air Services LLC · Saint Johns, MIBuilt 1966 · S/N 15063938N7843FDas Manoj Kumar · Buffalo Grove, ILBuilt 1966 · S/N 15063943
Back to AD 2009-10-09 R2