AD 2011-06-10

Registered aircraft · 998

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-06-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-06-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.

N132LTCobblestone Capital Aviation LLC · Sylacauga, ALBuilt 2011 · S/N 4636493N133KBIsland Time Aviation LLC · Peachtree City, GABuilt 1996 · S/N 4636049N133WCRegistration Pending · Huntingdon, TNRegistration pendingBuilt 2000 · S/N 4636251N134STBetancourt Ramses · Key West, FLBuilt 2006 · S/N 4692038N135USJohn Hale · Temple, TXBuilt 1987 · S/N 46-08078N139LFLgd Properties Inc · Wylie, TXBuilt 2011 · S/N 4636505N13PCGj Aviation LLC · Mountain Lakes, NJBuilt 1984 · S/N 46-8408081N141SBCk Aviation LLC · Bismarck, NDBuilt 1999 · S/N 4636244N1438TFreedom Flyers II LLC · Islip, NYBuilt 2014 · S/N 4636615N143LAMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2009 · S/N 4636459N143PPBolch James R · Vero Beach, FLBuilt 2015 · S/N 4636664N144HPButler Christopher E · Fort Lauderdale, FLBuilt 2008 · S/N 4692044N146BUSaltwater Aviation LLC · Friday Harbor, WABuilt 1984 · S/N 46-8408057N146MSMagnolia Partners Aviation LLC · Lockesburg, ARBuilt 1984 · S/N 46-8408032N146NCHills Jason · Bothell, WABuilt 1998 · S/N 4636176N146RFValiair Limited Co Trustee · Casper, WYBuilt 2011 · S/N 4636502N146ZFNo Boundry Airplane LLC · Council Bluffs, IABuilt 1984 · S/N 46-8408002N149MMJsk Leasing LLC · Valparaiso, INBuilt 2008 · S/N 4692046N14BCSrdo Advanced Wound Care Associates Pllc · Dallas, TXS/N 4636014N14CXVortac LLC · Traverse City, MIBuilt 1988 · S/N 4608107N14EFInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 4622009N14PCAlooment LLC · Las Vegas, NVBuilt 1989 · S/N 4622027N151TMBehel Bobby O · Tuscumbia, ALBuilt 2010 · S/N 4636467N155MAOne Zero Three Six Papa LLC · Florence, SCBuilt 2019 · S/N 4636743N15EFEastern Aviation Fuels Inc · New Bern, NCBuilt 1999 · S/N 4636195N15XJSt Express LLC · El Segundo, CABuilt 2022 · S/N 4636796N1630WN O Good LLC · Wade, NCBuilt 2011 · S/N 4636508N163STD&E Aircraft LLC · Newark, OHBuilt 2010 · S/N 4692143N166MABryant Kristy D · Mckinney, TXBuilt 2009 · S/N 4692120N168GFC2c LLC · Christiansted, VIS/N 4636189N16LTClausen Frederik M · Lake Forest, ILBuilt 1988 · S/N 4608130N171MElevated Holdings Inc · Newport Beach, CABuilt 2024 · S/N 4636841N176HPSouthern On Call Services Inc · Andersonville, GABuilt 2008 · S/N 4692076N177HCQualitair LLC Trustee · MichaelstadtBuilt 2001 · S/N 4636314N177MASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1994 · S/N 4622177N178DBPrm Enterprises Inc · Manchester, NHS/N 4636333N179BLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 4692060N179STAxis Label Inc · Hilliard, FLBuilt 2008 · S/N 4692003N17NGParmer Construction Company LLC · Terrell, TXBuilt 1987 · S/N 4608074N181TRPk Financial Consulting LLC · Chandler, AZBuilt 2013 · S/N 4636580N183HPSotereanos Ltd · Mckeesport, PABuilt 2008 · S/N 4692083N186STInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 4692086N188KCMalibu Management LLC · Ponte Vedra, FLBuilt 2013 · S/N 4636588N188LAAvf Flyers LLC · Richmond, VAS/N 4636185N188LGMyskinmedspa LLC · Rockledge, FLBuilt 1989 · S/N 4622043N189MHSpirit Life Inc · Morrison, COBuilt 1998 · S/N 4636159N18JMDixon John F · Hayden, IDBuilt 1999 · S/N 4636229N18JSAdelaar Holdings LLC · Missoula, MTBuilt 2016 · S/N 4636702N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045N190KCHi Fly Aviation LLC · Harrisonburg, VABuilt 2008 · S/N 4692090
Back to AD 2011-06-10