OpenAirDocs.org
AD 2016-01-01

Registered aircraft · 410

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.

N1032GOsgood Air LLC · Hays, KSBuilt 2006 · S/N 4697285N1032HPanhandle Air LLC · Destin, FLBuilt 2007 · S/N 4697302N1061TPlumbers Air Supply LLC · Overland Park, KSBuilt 2006 · S/N 4697274N1065YKerin Charles A Dvm · Wylie, TXS/N 4697295N10694H&A Aviation LLC · Anniston, ALBuilt 2007 · S/N 4697297N1071SEla Group Inc · Shreveport, LAS/N 4697298N108KKSafety First LLC · Missoula, MTBuilt 2010 · S/N 4697424N10STGocc Blue Sky LLC · Augusta, GABuilt 2005 · S/N 4697220N111RCSpiga Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 4697330N113FTGarnet Ridge LLC · Brooksville, FLBuilt 2006 · S/N 4697280N113T73tj LLC · Clifton Park, NYBuilt 2007 · S/N 4697312N117PWCommand Air LLC · Arlington, VABuilt 2001 · S/N 4697030N118JVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4697235N119TPJt Executive Properties LLC · Italy, TXBuilt 2008 · S/N 4697386N120WWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 4697047N121MACisnero Francisco Javier Picazo · Mckinney, TXBuilt 2009 · S/N 4697406N121NSPorto Mark · Wilmington, DEBuilt 2007 · S/N 4697292N121TRRay Timothy E · Fort Walton Beach, FLBuilt 2019 · S/N 4697669N123TSRyen Air LLC · Wilmington, DEBuilt 2005 · S/N 4697219N126STNextgen Flyers LLC · Ephrata, PABuilt 2011 · S/N 4697465N128CTaylor Chevrolet Co · Rexburg, IDBuilt 2013 · S/N 4697528N129EJShelbyville Auto Sales LLC · Shelbyville, TNBuilt 2001 · S/N 4697065N130URegistered aircraftBuilt 2018 · S/N 4697644N133PKFinn And Conway Inc · Bridgeview, ILBuilt 2004 · S/N 4697196N133SRBas Part Sales LLC · Greeley, COBuilt 2001 · S/N 4697114N134ME D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2003 · S/N 4697169N135FLAfdflt LLC · Mount Vernon, ILBuilt 2002 · S/N 4697135N135JMBill White Transportation LLC · Poteau, OKS/N 4697072N137KMAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2001 · S/N 4697091N138CMMam Consulting LLC · Keller, TXBuilt 2014 · S/N 4697579N138YNw Ventures LLC · Palo Alto, CAS/N 4697505N142EEHound Dog Aircraft LLC · Lawrence, KSBuilt 2005 · S/N 4697217N14GVScott T LLC · Portland, ORS/N 4697092N152ALN152al LLC · Tulsa, OKBuilt 2004 · S/N 4697182N152WFMcmanus Russel · Chicago, ILBuilt 2001 · S/N 4697035N153TCCroley Equipment Leasing LLC · Ocala, FLBuilt 2007 · S/N 4697307N154DRN154dr LLC · Brush, COS/N 4697034N15FKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 4697469N15SASkytrain LLC · Markle, INBuilt 2015 · S/N 4697599N168RVAkn Enterprises LLC · Springfield, MOBuilt 2006 · S/N 4697252N170LAEducators Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4697341N171HPAlliance Diversified Enterprises Inc · Escondido, CABuilt 2008 · S/N 4697371N172MAN172ma LLC · Miramar Beach, FLBuilt 2006 · S/N 4697263N175MADakota Equipment LLC · Bismarck, NDBuilt 2011 · S/N 4697461N175NCapital Consulting LLC · Newport Beach, CABuilt 2008 · S/N 4697370N175WBHerdair Group LLC · Conroe, TXBuilt 2004 · S/N 4697181N176MAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4697729N17LHHigh Flying Investments LLC · Texarkana, ARBuilt 2000 · S/N 46-97007N17PL2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 2014 · S/N 4697551N184AEN184ae LLC · Ault, COBuilt 2000 · S/N 4697026
Back to AD 2016-01-01