OpenAirDocs.org
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.

N186PSRricko LLC · Portland, ORS/N 4697228N187JDMacarthur Dougald F · Littleton, NHBuilt 2004 · S/N 4697180N188CECruise Air LLC · Wilmington, DEBuilt 2005 · S/N 4697239N188PMCairn Vista Holdings LLC · Santa Rosa, CABuilt 2012 · S/N 4697501N191DBMeridian Logistics LLC · Forest Lake, MNBuilt 2005 · S/N 4697232N1968WPtt Aircraft Management Inc · Newport Beach, CABuilt 2001 · S/N 4697115N199CPKbl Cvx LLC · Bellaire, MIBuilt 2001 · S/N 4697099N19CXSingle Windmill Ranch LLC · Austin, TXBuilt 2001 · S/N 4697077N1RQEnthios Enterprises LLC · Columbus, INS/N 4697112N203APHi-Tech Air Holdings LLC · Austin, TXBuilt 2010 · S/N 4697444N209STSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N 4697209N20PCMyrtlewood Aviation LLC · Tampa, FLBuilt 2007 · S/N 4697327N215PASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 4697347N215SDEastern Stearman Inc Trustee · Leesburg, VABuilt 2001 · S/N 4697049N219BCArcovia Air LLC · Loganville, GABuilt 2006 · S/N 4697284N21EPC&J Aviation LLC · Orono, MNBuilt 2012 · S/N 4697500N220UM3k Aviation LLC · Birmingham, MIBuilt 2004 · S/N 4697183N225MAAerial Services Inc · Cedar Falls, IABuilt 2001 · S/N 4697106N231CMQet Aircraft Services LLC · Rancho Viejo, TXBuilt 2002 · S/N 4697146N2325DBeck Sod Farm Inc · Palms, MIBuilt 2008 · S/N 4697339N234PMDiamond Enterprises LLC · Lincoln, NEBuilt 2005 · S/N 4697200N235TWSalcedo Enrique · San Diego, CABuilt 2003 · S/N 4697157N237JMBrekke Aviation Inc · Edmore, NDBuilt 2001 · S/N 4697078N237STIlluminus Aviation LLC · Chicago, ILBuilt 2005 · S/N 4697237N2406PAam Aeromed LLC · Wilmington, DEBuilt 2011 · S/N 4697448N240ERAlexander Aviation LLC · Scottsdale, AZBuilt 2011 · S/N 4697447N2418WSierra Tango Air LLC · Sycamore, ILBuilt 2011 · S/N 4697464N241PMBryants Aviation Inc · Batesville, ARBuilt 2003 · S/N 4697150N2424UOregon Air Classics LLC · Fife, WABuilt 2011 · S/N 4697459N244DFPapa 46 Ventures LLC · Ellenton, FLBuilt 2010 · S/N 4697445N247TJNicholas Sol · Colorado Springs, COBuilt 2014 · S/N 4697561N248DAJb Air Services LLC · Brighton, COBuilt 2003 · S/N 4697156N250SAAircraft Partner Holdings Inc Trustee · BerlinBuilt 2000 · S/N 46-97004N2519FAmerican Aviation Inc · Brooksville, FLBuilt 2012 · S/N 4697494N252CValiair Lc Trustee · Casper, WYBuilt 2012 · S/N 4697498N25324Central Valley Air LLC · Logan, UTBuilt 2013 · S/N 4697519N255DWHales Gutter Guys LLC · Sedona, AZBuilt 2000 · S/N 4697020N255RZIsr Aviation LLC · Wilmington, DES/N 4697504N2590UBlue & Gold LLC · South Boston, VABuilt 2013 · S/N 4697514N25WRTl Lobo Group LLC · Rockwall, TXBuilt 2006 · S/N 4697269N25ZMVitale Matthew J · Ocala, FLBuilt 2007 · S/N 4697309N260PMCatrina LLC · College Station, TXBuilt 2014 · S/N 4697545N264B264b LLC · Wilmington, DEBuilt 2001 · S/N 46-97028N265CYankee Tango Mike LLC · Dublin, TXBuilt 2011 · S/N 4697455N266TAlpha Zulu Holdings LLC · Arlington, VABuilt 2004 · S/N 4697188N26DRPepper Equipment Corp · Monte Vista, COBuilt 2008 · S/N 4697358N26KCInternational Air Services Inc Trustee · Carson City, NVS/N 4697113N270PSStevens Air LLC · Prosper, TXS/N 4697395N271JBValiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 4697512N277WTSfc LLC · Indianapolis, INBuilt 2006 · S/N 4697286
Back to AD 2016-01-01