OpenAirDocs.org
AD 2011-18-09

Registered aircraft · 128

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:2011-18-09')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-18-09')
  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.

N102RRMoyer Aviation Ll C · Katy, TXS/N 1477-5N103MPJoyce George E · Franklinville, NCS/N LF-50N117WBHicks Jacob · Crozet, VABuilt 1960 · S/N DH-275N123MKSolomon Steven · Cherry Hill, NJBuilt 1965 · S/N 26-141N132BABemidji Aviation Services Inc · Bemidji, MNS/N LD-331N1415BCaneel Enterprise LLC · Nibley, UTBuilt 1993 · S/N 0012N142TPGeorgia Florida Aviation Search Team · Monticello, FLBuilt 1962 · S/N LF-71N166SPSwitzer James DBA · Costa Mesa, CABuilt 1964 · S/N 26-79N184BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-68N208MLAngelo Sorce Md Pllc · Dandridge, TNBuilt 1962 · S/N LF-34N2315YMid Continent Aircraft Corp · Hayti, MOBuilt 1980 · S/N 36-8002040N2338XHangar 8 Spray Service LLC · Clark, SDS/N 36-8202007N2352XFlying G Aviation Inc · Drayton, NDBuilt 1982 · S/N 36-8202012N2407VPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 36-8002019N2409VPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 36-8002020N2412XMid Continent Aircraft Corp · Hayti, MOBuilt 1982 · S/N 36-8302001N24410Storm Spraying Service Inc · Webster City, IABuilt 1982 · S/N 36-8302012N2451VHatfield Spraying Service Inc · Nunica, MIBuilt 1980 · S/N 36-8002028N2782YDegroff Steven A · Berne, INBuilt 1964 · S/N 26-59N3801EAcwercs International Inc · Wilmington, DES/N 36-7802006N3833EValley Spraying Service LLC · Gann Valley, SDBuilt 1978 · S/N 36-7802024N3957EAurora Cooperative Elevator Co · Aurora, NEBuilt 1978 · S/N 36-7802069N3958EJohnson Lynn L · Grafton, NDBuilt 1978 · S/N 36-7802070N3980EOse Airspray LLC · Thief River Falls, MNS/N 36-8302022N3982EFresno Westside Mosquito Abatement District · Firebaugh, CABuilt 1979 · S/N 36-7902027N3993EStorm Spraying Serv Inc · Webster City, IABuilt 1978 · S/N 36-7802052N40013Teufel Larry · Portland, ORS/N H-2N400BVCarello Aerospace LLC · Deltona, FLS/N 1941N400CJDeepe Mark D · York, NEBuilt 1964 · S/N 26-5N400EDavis Richard · Reno, NVBuilt 1964 · S/N 26-15N400FKFinazzo Joseph · Fort Mohave, AZS/N 26-47N400FW400fw LLC · Largo, FLBuilt 1964 · S/N 26-51N400GCNorthern Sky Aviation LLC · Harbor Springs, MIBuilt 1965 · S/N 26-80N400GUTriple S Aviation LLC · Wilmington, DEBuilt 1964 · S/N 26-32N400HLSale Reported · Lamesa, TXSale reportedBuilt 1964 · S/N 26-86N400HPMorgan David W · Canton, MIBuilt 1964 · S/N 26-16N400HRDavis Gary L · Burleson, TXS/N 26-118N400KKDennehey Patrick N · Cameron Park, CABuilt 1965 · S/N 26-103N400NQN400nq LLC · Gleeley, COS/N 26-29N400PAN6105s LLC · Norwood, NCBuilt 1964 · S/N 26-54N400PPMig Aviation LLC · Sandy, UTS/N 26-28N400SWDay Stephen F · Queen Creek, AZS/N 26-112N400WGRegistered aircraftBuilt 1965 · S/N 26-104N400WLHammer Construction Corp · Miami, FLBuilt 1965 · S/N 26-148N400YKarschney Rich · Seattle, WABuilt 1965 · S/N 26-101N41323Demars Kevin L · Fargo, NDS/N 36-7460001N4153EGardner Gary A · Estherville, IABuilt 1979 · S/N 36-8002003N4154EPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 36-8002004N41HWFresh Air Aviation Inc · Charlevoix, MIS/N LF73N5078EBemidji Aviation Services Inc · Bemidji, MNBuilt 1963 · S/N LF-76
Back to AD 2011-18-09