AD 2016-05-13

Registered aircraft · 3,126

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-05-13')
    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-05-13')
  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.

N847FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0156N848FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0158N848HAAerial Applicators Of Missouri LLC · Qulin, MOBuilt 2020 · S/N 802A-0868N84BDWhite Birch Transportation · Lee, NHBuilt 2002 · S/N 20800353N84FCWilliams Fertilizer Services LLC · Oregon, MOBuilt 1994 · S/N 402-0946N84HSGc N84hs LLC · Layton, UTS/N 50N85022Bergo LLC · Harrisburg, ARBuilt 2001 · S/N 402A-1140N8502ATumbleweed Leasing LLC · Tacoma, WABuilt 2002 · S/N 502-0647N8502HPope James D · Lewiston, IDS/N 802-0140N8504RRussell Armstrong And Danny Hawk DBA · Yuba City, CABuilt 2001 · S/N 802A-0123N8504TWakefield Aircraft LLC · Cooperstown, NDBuilt 2005 · S/N 802A-0218N8506PDownstown Airport Inc · Vineland, NJBuilt 2002 · S/N 602-0646N8506VKubecka Daniel P · Edna, TXBuilt 2003 · S/N 502B-0650N8507KA & M Flying Service Inc · Carlise, ARBuilt 2001 · S/N 802A-0122N8507NTumbleweed Leasing LLC · Tacoma, WABuilt 2003 · S/N 802A-0158N8507SVan Namen Jonathan · Benoit, MSBuilt 2003 · S/N 502B-0664N8509SAir Tractor Inc · Olney, TXBuilt 2003 · S/N 802A-0164N8509TCrop Jet Aviation LLC · Gooding, IDS/N 802A-0152N850DTalfin Leasing LLC · Heflin, ALBuilt 1992 · S/N FL-70N850WRAg-Tech Aviation Inc · Leland, MSBuilt 2001 · S/N 502B-0643N8511QDaniels Aviation Inc · Inverness, MSS/N 602-0665N8516JG3 Flying LLC · Merigold, MSS/N 602-0671N8516KFlatland Aviation LLC · Indianola, MSBuilt 2003 · S/N 502B-0669N8519VAdams Aerial Solutions LLC · Decatur, ILBuilt 2004 · S/N 502B-0686N851BFF & M Flying Service LLC · Columbus, MSBuilt 2022 · S/N 802A-0996N851CHCkw Aviation LLC · Dalhart, TXBuilt 2024 · S/N 802A-1170N851DCKansas Farm & Ranch Inc · Seneca, KSBuilt 2021 · S/N 802A-0921N851EMLos Angeles Police Department · Los Angeles, CABuilt 1976 · S/N 73-22259N851FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0166N851LASun Valley Dusting Co · San Benito, TXBuilt 2014 · S/N 502A-2951N8521PThomas Air Service Inc · Hastings, NEBuilt 2004 · S/N 402B-1148N8521QCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2005 · S/N 502B-2572N8521VJones Flying Service · Biggs, CABuilt 2004 · S/N 602-0690N8521WA & M Flying Service Inc · Carlisle, ARBuilt 2004 · S/N 802A-0167N8521ZAir Care Leasing LLC · Lamar, COBuilt 2004 · S/N 502B-0693N8522SDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 802A-0161N8522YAero Applications Inc · Burley, IDBuilt 2004 · S/N 802A-0188N85239Shelton Agri Services Inc · Hereford, TXBuilt 2005 · S/N 602-1130N8523JA & M Flying Service Inc · Carlisle, ARBuilt 2011 · S/N 802A-0394N8523LTwin Cities Aviation Inc · Yuba City, CABuilt 2005 · S/N 802A-0203N8524FWallin Michael L · Walnut Ridge, ARBuilt 2005 · S/N 602-1132N8524HMitchell Andrew D Trustee · Winnie, TXS/N 802A-0163N8524LTri Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N 802A-0202N8524QMid-Cal Ag Aviation Inc · Kerman, CABuilt 2005 · S/N 502B-2580N8525FJlr Ag Aircraft LLC · Fowler, COBuilt 2005 · S/N 402B-1169N8525QMagnum Aviation LLC · Goff, KSBuilt 2005 · S/N 802A-0222N8526LJack Olham Oil Inc · Dumas, TXBuilt 2005 · S/N 402B-1167N852DK402wd Holdings LLC · Corpus Christi, TXBuilt 2013 · S/N 502A-2904N853ALMetro Aviation Inc · Shreveport, LABuilt 1996 · S/N 168N853FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0170
Back to AD 2016-05-13