AD 2016-01-01

Registered aircraft · 412

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

N53ALMsa Pinnacle LLC · Bentleyville, OHBuilt 2006 · S/N 4697287N53KBHiers Properties Of Delaware LLC · Chattanooga, TNBuilt 2005 · S/N 4697231N53PKSpantech LLC · Glasgow, KYS/N 4697093N54199Key Aviation Group LLC · Meridian, MSBuilt 2003 · S/N 4697164N541NDBig Sky Flight LLC · Helena, MTBuilt 2008 · S/N 4697356N546MAWilliams Joel A · Rocky Face, GABuilt 2007 · S/N 4697331N54RGRemc Leasing LLC · Bismarck, NDBuilt 2011 · S/N 4697478N550CRCwr Holdings LLC · Wilmington, DEBuilt 2001 · S/N 4697031N555AUInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 4697338N555GPPlane Intentions LLC · Lobelville, TNBuilt 2013 · S/N 4697534N556BATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4697404N55ZGDixie Painting & Sandblasting Inc · Northport, ALBuilt 2001 · S/N 4697082N560HPRjc Rental Properties LLC · San Diego, CABuilt 2001 · S/N 4697045N562DCPresent Course Investments LLC · Coronado, CABuilt 2011 · S/N 4697473N562HPAir Agco LLC · Bell City, MOBuilt 2002 · S/N 4697139N565CHensley Tyler Shea · Fayetteville, NCBuilt 2004 · S/N 4697173N565HPLindstrom Troy D · Crossville, TNBuilt 2005 · S/N 4697211N566MA814 Cartmell LLC · Dover, DEBuilt 2008 · S/N 4697391N568HPCkinchen Enterprises LLC · Spring, TXBuilt 2007 · S/N 4697306N575CATmofly LLC · Suffolk, VABuilt 2011 · S/N 4697452N577HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4697377N577KC1906 Aviation LLC · Greenwood, SCBuilt 2014 · S/N 4697577N57ATJp Bcbnz Holdings LLC · Clinton, MDS/N 4697350N587DFTardis Leasing LLC · Fort Myers, FLBuilt 2006 · S/N 4697247N58BTValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 4697289N59WFLes Chardons Inc Trustee · Wilmington, DEBuilt 2001 · S/N 4697042N5PPVerplowens Aviation LLC · Steamboat Springs, COBuilt 2002 · S/N 4697145N600KSPlane Fun Inc Tr Trustee · Snellville, GAS/N 4697017N601RHN601rh LLC · Helena, MTBuilt 2001 · S/N 4697109N606WCFlight Unlimited LLC · Smyrna, GABuilt 2004 · S/N 4697176N6072JSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N 4697417N6074JFive Miles Up LLC · Sisters, ORBuilt 2009 · S/N 4697397N6077QTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4697383N607MAAllen Kelvin T Trustee · Canyon, TXBuilt 2001 · S/N 4697107N6081ERegistered aircraftBuilt 2009 · S/N 4697400N6101GPack Aviation LLC · San Jose, CABuilt 2008 · S/N 4697340N6105DLankenau John · Lake Havasu City, AZBuilt 2010 · S/N 4697426N611AKConverse Richard L Jr · Durango, COBuilt 2003 · S/N 4697163N615WASanderson Aviation2 LLC · Flower Mound, TXBuilt 2015 · S/N 4697594N618MAAir Matrix LLC · Lomita, CABuilt 2005 · S/N 4697218N618STT Spare Leasing LLC · Waldo, OHBuilt 2007 · S/N 4697318N619TKRegistered aircraftBuilt 2006 · S/N 4697243N61KPFlying Coyote Productions LLC · Oro Valley, AZBuilt 2006 · S/N 4697260N621NHorizon Aviation LLC · Kalispell, MTBuilt 2004 · S/N 4697177N623DTaylor Steve B · Albuquerque, NMBuilt 2009 · S/N 4697416N623FGDyeraviation LLC · College Station, TXBuilt 2017 · S/N 4697623N62LTLima Tango LLC · Mariposa, CABuilt 2001 · S/N 4697027N634STDc Skies LLC · Pasadena, CABuilt 2018 · S/N 4697634N63SEG B Aerial Applications Inc · Slaton, TXBuilt 2007 · S/N 4697333N64AAProspect Aviation Montana LLC · Missoula, MTBuilt 2016 · S/N 4697608
Back to AD 2016-01-01