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.

N65PVRhrsc LLC · Tucson, AZS/N 4697086N668KCJohn A Lester LLC · Union City, TNBuilt 2006 · S/N 4697268N675MAOwyhee Produce LLC · Parma, IDBuilt 2008 · S/N 4697367N675RCSparrow Holdings LLC · Hawley, MNBuilt 2012 · S/N 4697507N676MADlc Aviation Inc Trustee · Wilmington, DEBuilt 2009 · S/N 4697407N678ABHeart Rhythm Center Of Mississippi LLC · Flowood, MSBuilt 2001 · S/N 4697041N67BWHarvey Robert B Jr · Fort Worth, TXBuilt 2000 · S/N 46-97011N681RVDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2012 · S/N 4697481N684KMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 4697353N698ATNugent Inc · Indianapolis, INBuilt 2001 · S/N 4697059N700BGSuisse Management LLC · Park City, UTBuilt 2011 · S/N 4697457N705MAJ K Air LLC · Columbus, INBuilt 2006 · S/N 4697277N706PMGizmo Aviation LLC · Roswell, NMS/N 4697210N711SBCashsouth LLC · Georgetown, DEBuilt 2001 · S/N 4697075N713WATempus Fugit LLC · Henderson, COBuilt 2013 · S/N 4697525N71RDRagincajun Aviation LLC · Missoula, MTBuilt 2010 · S/N 4697438N720FGClark Charles · Basking Ridge, NJBuilt 2025 · S/N 4697720N721MTThesman One Investments LLC · Las Vegas, NVBuilt 2008 · S/N 4697362N723KGcn Investments LLC · Hastings, NEBuilt 2008 · S/N 4697348N724HAPriori Holdings Inc · Jacksonville, FLBuilt 2008 · S/N 4697375N726WAWestern Aircraft Inc · Boise, IDBuilt 2025 · S/N 4697726N72CBFlatland Aviation LLC · Aberdeen, SDBuilt 2014 · S/N 4697548N72WYBas Part Sales LLC · Greeley, COBuilt 2007 · S/N 4697322N731BRPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4697731N731JBLea Kenneth R Trustee · St Charles, ILS/N 4697343N731VGCoastal Meridian LLC · El Segundo, CAFirst renewal noticeBuilt 2007 · S/N 4697326N733PBw69 Air LLC · Fort Walton Beach, FLBuilt 2001 · S/N 4697052N73VKBsnt LLC · Mooresville, NCBuilt 2009 · S/N 4697421N747XTEp747xt LLC · Miamisburg, OHBuilt 2006 · S/N 4697261N752MMMc Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 4697192N753CGaviota Holdings LLC · Goleta, CABuilt 2006 · S/N 4697248N759HPerfect Solutions Inc · Elma, NYBuilt 2006 · S/N 4697245N767TPNuage Holdings LLC · Sioux Falls, SDBuilt 2001 · S/N 4697036N76KJA&D Terminal Management LLC · Towaco, NJBuilt 2012 · S/N 4697502N76MGCook Brothers Farms LLC · Princeton, KYBuilt 2001 · S/N 4697056N76VBPiper Aircraft Inc · Vero Beach, FLS/N 4697732N77400Pettit Brian · Wshngtn Ct Hs, OHBuilt 2005 · S/N 4697206N777MGSe Aviation LLC · Champlin, MNS/N 4697066N77BTWings Up LLC · Kansas City, MOBuilt 2014 · S/N 4697554N77VFOrions Victor Foxtrot LLC · Truckee, CABuilt 2009 · S/N 4697408N7818MFlynn Bec Gp Inc · Spokane, WABuilt 2015 · S/N 4697582N7873CFlying Goat LLC · San Diego, CAS/N 4697378N795FApplegarth Investment Co LLC · Kentfield, CABuilt 2007 · S/N 4697316N796JDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4697372N7UJMad Logging LLC · Sturgeon, MOS/N 4697226N802MMAuburn Air Leasing LLC · Kalispell, MTBuilt 2002 · S/N 4697148N804JHRocky Mountain Boat Co · Pueblo West, COBuilt 2001 · S/N 4697044N808LASouth Bound Holdings LLC · Knoxville, TNBuilt 2008 · S/N 4697392N815CFMeridian Air LLC · New Boston, MIBuilt 2006 · S/N 4697242N816BCAv8me LLC · Spicewood, TXBuilt 2004 · S/N 4697195
Back to AD 2016-01-01