AD 2012-16-14

Registered aircraft · 779

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

N1PUSmn Investments Inc · Greeneville, TNBuilt 2011 · S/N HA-0201N1STSkyship 45xr LLC · Englewood, COBuilt 2011 · S/N 429N200FJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1980 · S/N 408N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336N200WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 352N205WPAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1974 · S/N 306N208GCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N HA-0206N209CQFalcon 900ex Msn 98 LLC · New Castle, DEBuilt 2001 · S/N 98N209MDRa Aviation Holdings LLC · Prosper, TXBuilt 2010 · S/N 2127N20GPN83 Charlie Inc · Fort Wayne, INBuilt 1992 · S/N 113N211TAG150-223 LLC · Easton, MDBuilt 2007 · S/N 223N211WGPentair LLC · Palmetto, FLBuilt 2006 · S/N 142N213RDAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2009 · S/N HA-0108N214DVRk-492 Leasing LLC · Miami, FLBuilt 2007 · S/N 350N214TDHarbor Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 258332N214TGTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2007 · S/N 328N215PRSalang Aviation LLC · Corpus Christi, TXBuilt 2006 · S/N 315N217MJMtk Leasing LLC · Woodburn, ORBuilt 2002 · S/N 217N217MSS&S Aviation LLC · Florence, ALBuilt 2007 · S/N 217N219JLFoundation Holdings LLC · Jonesboro, ARBuilt 2005 · S/N 267N219RBPauli-Mar Investment Co · Warren, MIBuilt 2006 · S/N 2058N21NBNorthbound Air LLC · Fayetteville, ARBuilt 2006 · S/N 2045N220PFExecutive Air Taxi Corp · Bismarck, NDBuilt 2001 · S/N 258542N221CBFalcon 50ex 320 LLC · Miami Gardens, FLBuilt 2001 · S/N 320N221WRWagner Richard S · Plano, ILBuilt 2008 · S/N 360N222HKNdw Hawk LLC · Laurel, MSBuilt 2008 · S/N 248N222NEHigher Cause LLC · Grand Rapids, MIBuilt 2000 · S/N 110N224GBBrb Leasing LLC · Dallas, TXBuilt 2006 · S/N 307N224JL205 Flintstones LLC · Flint, MIBuilt 1995 · S/N 258279N224SBBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 102N229LJN229lj LLC · Bentonville, ARBuilt 2001 · S/N 229N22CPRegistered aircraftBuilt 2003 · S/N 258624N22GGoodyear Tire & Rubber Co · Akron, OHBuilt 2009 · S/N 282N22VSRgn Aviation LLC · Marco Island, FLBuilt 2008 · S/N HA-0047N230TGThurston Aviation LLC · Vero Beach, FLBuilt 1996 · S/N 086N232EAAventure Aviation LLC · Captiva, FLBuilt 2009 · S/N HA-0107N239SRApple Realty Group Inc · Richmond, VABuilt 2006 · S/N 2049N23FEMesiner Aircraft Inc · Janesville, WIBuilt 2011 · S/N HA-0189N241LJDouble Whiskey Aviation LLC · Midland, TXS/N 241N244CKKalitta Air LLC · Ypsilanti, MIBuilt 1977 · S/N 369N245KLear 245 LLC · Fayetteville, ARBuilt 2005 · S/N 269N247JHWair Next LLC · Amelia, OHBuilt 2007 · S/N 344N247PSRed Clay Aviation LLC · Pineville, NCBuilt 2006 · S/N 215N247RE724 Aviation LLC · Bloomfield Hills, MIBuilt 2008 · S/N HA-0066N248BPNorth Valley Air Ltd · St Thomas, VIBuilt 1998 · S/N 283N248BTDelsey LLC · Newport Beach, CABuilt 2011 · S/N 258N248LXHaus Of Suss LLC · Dallas, TXBuilt 2009 · S/N 248N24GGoodyear Tire & Rubber Co · Akron, OHBuilt 2010 · S/N 289N24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLS/N 35-037N250EXAb Aspen LLC · Opa Locka, FLBuilt 2001 · S/N 139
Back to AD 2012-16-14