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.

N7030FPaul William · Windfall, INBuilt 1966 · S/N 15063630N7030SAcoba Dylan Anthony · Orangevale, CABuilt 1967 · S/N 15067730N7031SBurns Randall A · Rogers, ARBuilt 1967 · S/N 15067731N7032STamayo Ernest R · Dripping Springs, TXS/N 15067732N7038GRoeder Blaine W · El Prado, NMBuilt 1973 · S/N 15074609N7039FWharam Glen A · Park River, NDBuilt 1966 · S/N 15063639N7039GWood Donna L · Wisconsin Dells, WIBuilt 1973 · S/N 15074610N7040FVtf LLC · Winter Haven, FLBuilt 1966 · S/N 15063640N7041SMaclean John A · Glenview, ILBuilt 1967 · S/N 15067741N7042FKadlecovic Martin · Prescott, AZS/N 15063642N7042SNuernberger Howard P · State College, PABuilt 1967 · S/N 15067742N7043SBaughman Jeffrey S · Keller, TXBuilt 1967 · S/N 15067743N7044FHanson Mike D · Vinton, IABuilt 1966 · S/N 15063644N7045SDiblasi Francis L · Shelton, CTBuilt 1967 · S/N 15067745N7047FVanderlei Lowell B · Springfield, SDBuilt 1966 · S/N 15063647N7047SHaley William R III · Carrollton, GABuilt 1967 · S/N 15067747N704AAWasatch Industries LLC · Ogden, UTBuilt 1976 · S/N 15078448N704ACRegistered aircraftBuilt 1976 · S/N 15078450N704AEYocom Jason D · Cocoa, FLBuilt 1976 · S/N 15078452N704AHN704ah LLC · Darien, WIBuilt 1976 · S/N 15078455N704ASAuger Allan D · Conifer, COS/N 15078464N704ATLongnecker Michael · Stuttgart, ARFirst renewal noticeBuilt 1976 · S/N 15078465N704AULosey Rodric O · Nipomo, CABuilt 1976 · S/N 15078466N704AWKroeger Dean · Two Rivers, WIBuilt 1976 · S/N 15078468N704AYAndreasen Mark D · Ridgefield, WABuilt 1976 · S/N 15078470N704AZFrantz Dean A · Adrian, MIBuilt 1976 · S/N 15078471N704BEGore Cleveland · Manning, SCS/N 15078475N704BGJones Kermit L III · Jasper, ALBuilt 1976 · S/N 15078477N704BHCloud Buddies LLC · Charlotte, NCBuilt 1976 · S/N 15078478N704BMEdwards Richard V · Acampo, CABuilt 1976 · S/N 15078482N704BRRourke William P · Lavonia, GAS/N 15078486N704BZFranks John W · Barberton, OHBuilt 1976 · S/N 15078494N704CACircle S Aviation LLC · Starkville, MSBuilt 1976 · S/N 15078495N704CBLewis Stephen · Hayden, IDBuilt 1976 · S/N 15078496N704CEB2w Corporation · Winona, MNBuilt 1976 · S/N 15078498N704CFWilbur Blake G · Kent, WABuilt 1976 · S/N 15078499N704CMCarpenter Devon W · Mountain Top, PABuilt 1976 · S/N 15078505N704CNTm Aero Marine Inc · North Miami, FLBuilt 1976 · S/N 15078507N704CSHolloway James H · Merritt Island, FLBuilt 1976 · S/N 15078511N704CURogers Gale Allen · Jonesborough, TNBuilt 1976 · S/N 15078513N704CXAlbatross Air Inc · Beaver, WVBuilt 1976 · S/N 15078516N704CYKimbrel Michael R · Shreveport, LABuilt 1976 · S/N 15078517N704CZCook David · Tucson, AZBuilt 1977 · S/N 15078518N704DBAndrews University · Berrien Springs, MIBuilt 1976 · S/N 15078519N704DFMaples Andrew L · Wilmington, DES/N 15078523N704DGEastern Florida State College · Cocoa, FLBuilt 1976 · S/N 15078524N704DHDelaware River Flyers LLC · Dover, DEBuilt 1976 · S/N 15078525N704DJStevens Robert L · Wauseon, OHBuilt 1976 · S/N 15078526N704DMTodd R Ray · Lewisville, NCBuilt 1976 · S/N 15078529N704DSMeza Mike A · Aledo, TXBuilt 1976 · S/N 15078534
Back to AD 2009-10-09 R2