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.

N7943FRegistered aircraftBuilt 1966 · S/N 15064043N7944FBrown R Ed · Vandalia, ILS/N 15064044N7946FPaul Paulson A · Kipnuk, AKBuilt 1966 · S/N 15064046N7949FMaciol Michael W M D · Pelham, NYBuilt 1973 · S/N A1500452N7952FKagey Ryan D · Seabrook, TXBuilt 1966 · S/N 15064052N7952GPlunkett Charles K E · Eagle Point, ORS/N 15074743N7953GSnyder Kenneth C · Lonsdale, MNBuilt 1973 · S/N 15074744N7954FVikingland Flying Club · Alexandria, MNS/N 15064054N7955FN7955f LLC · Titusville, FLS/N 15064055N7956FFios Flightline LLC · Tucson, AZBuilt 1966 · S/N 15064056N7962FFlying Colors Airparts Inc · Leesburg, FLBuilt 1966 · S/N 15064062N7968FFlyin Cowboys · Manning, NDBuilt 1966 · S/N 15064068N796BGFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 15280215N7970FConnor Christopher Donnie · Chicago, ILBuilt 1966 · S/N 15064070N7971FJanes Christopher D · Columbia, KYBuilt 1966 · S/N 15064071N7971UHallstrom Curtis R · Barnesville, OHBuilt 1976 · S/N 15077873N7974FMerriam Hugh M · San Leandro, CABuilt 1966 · S/N 15064074N7979FAtkins Adam T · Fort Mill, SCBuilt 1966 · S/N 15064079N7982FPlane Sane C1 LLC · Cary, NCS/N 15064082N7983FKoons Brian D · Canton, OHBuilt 1966 · S/N 15064083N7987FMillican Troy · New Ulm, TXBuilt 1966 · S/N 15064087N7987GHigh Expose Inc · Woodbine, NJBuilt 1973 · S/N 15074748N798LALong Island Aviators LLC · Farmingdale, NYBuilt 1978 · S/N 15281645N7991UAlternate Air Inc · Seattle, WABuilt 1976 · S/N 15077876N7996FRounds Donald C DBA · Waller, TXS/N 15064096N7998FBooth Donald V · Denison, TXBuilt 1966 · S/N 15064098N7AABolyard Norma · O Brien, FLS/N 15072420N7LSChabrian Peggy · Port Orange, FLBuilt 1969 · S/N 15071402N7SQTangassi Sergio · Gilbert, AZBuilt 1966 · S/N 15063743N7STFairley Dustin L · Fairbury, NEBuilt 1966 · S/N 15064652N7UTVolunteer Aviation Foundation Inc · Tullahoma, TNBuilt 1974 · S/N 15076100N8001FJohnston Joshua T · Aurora, MOS/N 15064101N8003FNovember Fox LLC · Quilcene, WAS/N 15064103N8004SRege Bill · Cloverdale, CAS/N 15061604N8005SFletcher Michael A · Vancouver, WABuilt 1965 · S/N 15061605N8006SBering Capital LLC · Anchorage, AKBuilt 1965 · S/N 15061606N8007FSimms Peter W · Wellsville, NYFirst renewal noticeS/N 15064107N8007SGolden Aerial Services LLC · Erie, PABuilt 1965 · S/N 15061607N8009FRucinski Edward A · Climax, NCBuilt 1966 · S/N 15064109N800HEFredericks Kenneth L · Halliday, NDBuilt 1965 · S/N 15061602N800TYAvcorp Holdings Inc · Jackson, MIBuilt 1978 · S/N 15282202N8010FTorres Mora Jose Alberto · Modesto, CABuilt 1966 · S/N 15064110N8012FHood William T · Columbia, SCBuilt 1966 · S/N 15064112N8012SCollins Scott · Upland, CABuilt 1965 · S/N 15061612N8013SRedmond Angela L · Austin, TXBuilt 1965 · S/N 15061613N80146Chapter 15 Aviation Inc · Homer Glen, ILBuilt 1981 · S/N 15285354N8014SMurray Bart · Pacifica, CAS/N 15061614N8015FLewis L Dwight Jr · Lopez Island, WABuilt 1966 · S/N 15064115N8017SHughes Todd R · Rocky Ford, COS/N 150-61617N8019FLyman Kenneth R · Livermore Falls, MEBuilt 1966 · S/N 15064119
Back to AD 2009-10-09 R2