OpenAirDocs.org
AD 2011-18-51 R1

Registered aircraft · 785

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-51-R1')
    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-51-R1')
  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.

N212ADBrykin Leasing Corp · Celina, TXBuilt 1984 · S/N 273N2136TWalvoord Spraying Service LLC · Hickman, NEBuilt 1998 · S/N G6-148N2146SMoses Lake Warden Air Services Inc · Moses Lake, WABuilt 1998 · S/N G10-149N216CDLandry Camile J · Baton Rouge, LABuilt 1974 · S/N 323N217BHMorning Aero LLC · Colorado Springs, COBuilt 1984 · S/N 318N218MSSasha Air LLC · Hingham, MABuilt 1981 · S/N 95041N21GPKolob Canyons Air Services Inc · Wilmington, DEBuilt 1989 · S/N AC754BN2200QCarroll Flying Service Inc · Lake Providence, LABuilt 1998 · S/N G10-155N220JSMt Mgt LLC · Missoula, MTBuilt 1981 · S/N 1545 S.A.N222GKTri-County Sprayers Inc · Hamlin, TXBuilt 1997 · S/N G6-145N222MEClearwater Airco LLC · Anchorage, AKS/N 11338N2237DFountain Flying Service LLC · Moscow, IDBuilt 1996 · S/N G1-104N2239CJk Skyfarm LLC · Adairville, KYBuilt 1996 · S/N G10-128N2245SFernandez Rosario Yailin · Imperial, CAS/N G1-106N2250PPeterson Kenneth J DBA · Staples, MNBuilt 1997 · S/N G10-131N2254SRustys Flying Service · D Hanis, TXS/N G10-134N2256ATwin Cities Aviation Inc · Yuba City, CABuilt 1997 · S/N G10-135N225MMJ & M Aircraft Holding LLC · Bellaire, TXBuilt 1978 · S/N 11462N225TDCat Air LLC · Melba, IDBuilt 1980 · S/N 11635N226KLCbg LLC · Wilsonville, ORBuilt 1979 · S/N TC-321N226MKN226mk Corp Trustee · Wilmington, DEBuilt 2018 · S/N 441-0209N226XXInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N T245N2270CBenrud Aviation LLC · Rice, MNBuilt 1997 · S/N G10-136N2270SEarls Spray Service Inc · Breckenridge, MIBuilt 1997 · S/N G10-137N2271ZPlane LLC (The) · Grove, OKBuilt 1997 · S/N G6-147N227JTWoody Whitefish LLC · Salem, ORBuilt 1981 · S/N TT477AN227LCBemidji Aviation Services Inc · Bemidji, MNBuilt 1988 · S/N AC-707BN227LECbg LLC · Tualatin, ORBuilt 1993 · S/N DC837BN227LJMetro-Jet LLC · Downey, CABuilt 1982 · S/N AC-522N228SDGeneral Atomics Aeronautical Systems Inc · San Diego, CABuilt 1991 · S/N 8200N22CG316 Extreme LLC · Basalt, COBuilt 1979 · S/N 441-0119N22MZChurchill Robert Jr · Wasilla, AKS/N 158N233PJLwkimber Interests Management LLC · Houston, TXBuilt 1986 · S/N 441-0362N233RCRico Marketing Corporation · Flint, MIBuilt 1982 · S/N 441-0263N23NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0066N241DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-607BN2441KCarpe Caelum LLC · Joplin, MOBuilt 1978 · S/N 441-0053N245CFEagle Creek Aviation Services Inc · Indianapolis, INBuilt 1976 · S/N 11313N248JHExecutive King Air Transportation Inc · Wilmington, DEBuilt 1982 · S/N BE-126N249DHUas Transervices Inc · Boca Raton, FLBuilt 1985 · S/N AT-631BN24GTPia Avcenter LLC · Peoria, ILBuilt 1975 · S/N 11254N24PTN24pt LLC · Winter Park, FLBuilt 1977 · S/N 4410015N251ESLumphanan LLC · Adams, NEBuilt 1975 · S/N 11251N252BWMotor Vanguard LLC · Campbellsville, KYBuilt 1980 · S/N 423 S.A.N253SBN253sb Shares LLC · Liberal, KSS/N 4410258N253TATalon Air Service Inc · Soldotna, AKBuilt 1992 · S/N 20800222N255BHBig Horn Airways Inc · Sheridan, WYS/N 8110N25CTAerial Crop Care Co · Hebron, NDBuilt 1996 · S/N G1-105N2609PNtail LLC · Sheridan, WYBuilt 1979 · S/N 11617N260MCBig Horn Airways Inc · Sheridan, WYBuilt 1987 · S/N 8121
Back to AD 2011-18-51 R1