AD 2011-12-10

Registered aircraft · 2,765

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-12-10')
    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-12-10')
  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.

N115VCPoulikakos Aspasia D · Kifissia AthensNon-citizen corporation, flight hours not reportedBuilt 2000 · S/N 0917N116PGUnusual Attitudes LLC · Bates City, MOBuilt 2004 · S/N 3547N116VKAirborne LLC · Wilmington, DEBuilt 2018 · S/N 2547N117BAChopper Ag Services LLC · Samson, ALBuilt 2017 · S/N 2512N117LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 2007 · S/N 11714N1189Aeroluxe Aviation LLC · Nashville, TNBuilt 2014 · S/N 13711N118YLExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2004 · S/N 10399N119MJN119mj LLC · Honolulu, HIBuilt 2013 · S/N 13406N119SMPrestige Worldwide Helicopters LLC · Waukesha, WIBuilt 2000 · S/N 0918N11BMRobinson Helicopter Co · Torrance, CAS/N 15043N11GACrosswind Leasing LLC · Prescott, AZBuilt 2005 · S/N 10826N11HNVstol Aviation LLC · Houston, TXBuilt 2016 · S/N 14040N11RAMonkey Biziness LLC · Cherryville, NCS/N 1951N120ABHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2005 · S/N 10868N120AFAir First LLC · Kalispell, MTBuilt 1994 · S/N 2055N1212NHgh Holdings LLC · Wilmington, DEBuilt 2024 · S/N 14800N121AHSoul Shine LLC · Nashville, TNBuilt 2004 · S/N 10548N121MEEvergreen Empire LLC · Delano, CABuilt 2007 · S/N 11797N121RHHelirod LLC · Oro Valley, AZBuilt 2023 · S/N 14615N121SESpitzer Helicopter LLC · Woodland Hills, CABuilt 1997 · S/N 2747N121SXRegistered aircraftBuilt 2018 · S/N 14147N121TVSky Helicopters Inc · Eustace, TXBuilt 2012 · S/N 13214N122AACnt Aviation LLC · Lake Tapps, WABuilt 2006 · S/N 11228N122AKBarker Paul II · Rainbow City, ALBuilt 1991 · S/N 2028N122JGRepublic Construction Industries LLC · Englewood, OHS/N 0845N122PLSlip Stream Aviation Inc · Fort Mill, SCBuilt 2001 · S/N 3265N122RFDaniels Ronald C · Poughkeepsie, NYS/N 3397N122YBRobinson Helicopter Co · Torrance, CABuilt 2002 · S/N 3309N12396Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0646N123MPPrairie River Farm Inc · Watertown, SDBuilt 2010 · S/N 12796N123MVEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10664N123SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14727N123YWMaxwell Truck And Equipment LLC · State College, PABuilt 2005 · S/N 10606N12424Helicopter Academy Com LLC · Rehoboth Beach, DES/N 0130N12475Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0453N124ASJm Helicopters And Cattle LLC · Boynton Beach, FLS/N 11232N124HHRotorwing LLC · Sheffield, ILBuilt 2008 · S/N 12267N12536Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0786N1253PMaco Aviation Inc · Dayton, WABuilt 2007 · S/N 11715N125WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 10445N12615Helicopter Academy.Com LLC · Rehoboth Beach, DES/N 1205N12699Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0063N126GGRobinson Helicopter Co · Torrance, CAS/N 15056N126NSHelileasing Inc · Las Vegas, NVBuilt 1989 · S/N 1153N126SKSoky Helicopters LLC · Bowling Green, KYBuilt 2008 · S/N 12382N126VAHuber Airpark Civic Club LLC · Seguin, TXBuilt 1996 · S/N 2581N12715Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0103N1273Taf Investments LLC · Doraville, GABuilt 2021 · S/N 14489N127DMAircraft Leasing LLC · Peoria, ILBuilt 2017 · S/N 30023N127SHWaverly R22 LLC · Oklahoma City, OKBuilt 2007 · S/N 4116
Back to AD 2011-12-10