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.

N261WBNorthern Jet Sales LLC · Port Saint Lucie, FLBuilt 1975 · S/N 330N263MCBighorn Airways Inc · Sheridan, WYBuilt 1987 · S/N 8141N264SVBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 208B0462N264TSFoxtrot Aviation Services LLC · Canton, OHBuilt 1977 · S/N BE-24N266MCBighorn Airways Inc · Sheridan, WYBuilt 1988 · S/N 8150N267TCValkyrie Aero LLC · Mesa, AZBuilt 1990 · S/N T51N2691WCbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-655BN26959Bemidji Aviation Services Inc · Bemidji, MNBuilt 1986 · S/N AC-662BN26LHKavalair LLC Series A · Marion, MTBuilt 1974 · S/N SH-1925N2725NWisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1980 · S/N 441-0190N2728GCbg LLC · Wilsonville, ORBuilt 1989 · S/N AC-731N27442Mission Flight · El Monte, CABuilt 1989 · S/N AC750-BN2749GLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1971 · S/N 6047N274GCPro Aviation II LLC · Ogden, UTBuilt 1985 · S/N 441-0349N2750GLo Pilato Family Flights Inc · Wilmington, DEBuilt 1972 · S/N 6059N276CACbg LLC · Wilsonville, ORBuilt 1978 · S/N TC276N280KLCbg LLC · Wilsonville, ORBuilt 1978 · S/N TC-280N2820GColin Irons Diving And Pools Service · Denton, TXBuilt 1970 · S/N T26-178N28LHKavalair LLC Series B · Marion, MTBuilt 1968 · S/N SH-1851N28RQRealstaff Rocket LLC · Keizer, ORS/N 001N290KAN290ka LLC · Clare, MIBuilt 1974 · S/N LW59N290LBGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2020 · S/N GA-6-1497N29GDAriel Seafoods Aviation LLC · Destin, FLBuilt 1983 · S/N 15035N29PRGa Flying LLC · Kalispell, MTBuilt 1969 · S/N 6018N2NAHainline Charles H · Pearland, TXBuilt 1981 · S/N TT-474N2NQSurdex Corp · Chesterfield, MOBuilt 1982 · S/N 441-0307N2RAFlying Mu2 LLC · Reno, NVS/N 366SAN2YVTalkeetna Air Taxi Inc · Talkeetna, AKBuilt 1957 · S/N 207N3004KAg Solutions LLC · Satanta, KSBuilt 1994 · S/N G10109N3004VCarroll Flying Service Inc · Lake Providence, LABuilt 1995 · S/N G6120N3024ULarson Ag Inc · Stephen, MNBuilt 1994 · S/N G10-108N3061NGreat Plains Spraying Inc · Colby, KSBuilt 2012 · S/N G10-174N307PATgf Aviation LLC · Lafayette, LAS/N T307N3083ZSilverwings Ag LLC · Burlington, COBuilt 1995 · S/N G6-122N30854Cornerstone Financial Enterprises LLC · Mesquite, NVS/N 11229N308HKGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2013 · S/N FC308N309HGConstruction Helicopters LLC · Howell, MIS/N 309N3108BGas Wilson Inc · Traverse City, MIS/N AC509N3114GM E S LLC · Anchorage, AKBuilt 1984 · S/N AC-583N31171Cbg LLC · Wilsonville, ORBuilt 1985 · S/N AC-605N312MBN312mb LLC · Wilmington, DEBuilt 1981 · S/N BE-113N313JMFlatiron Air LLC · Hotchkiss, COBuilt 1983 · S/N 441-0312N316TTThompson Aviation LLC · Dennis, TXBuilt 1986 · S/N 441-0360N317BCAsc Aviation LLC · Kalispell, MTBuilt 1983 · S/N 441-0317N318AKN318ak LLC · Anchorage, AKBuilt 1978 · S/N 441-0070N31JVMarc Inc · Bolton, MSBuilt 1981 · S/N TT-453N32009Ecliax LLC · Craig, AKBuilt 1987 · S/N 20800022N320GBAloft Aviation Services LLC · Spartanburg, SCBuilt 1960 · S/N BA-509N320MCMcneely Charter Service Inc · West Memphis, ARBuilt 1987 · S/N AC688N321GMWestern News & Info Inc · Prescott Valley, AZBuilt 1981 · S/N 1505 SA
Back to AD 2011-18-51 R1