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

N100GXBrulecreek Aviation LLC · Park City, UTBuilt 2007 · S/N 228N101RXGb Aviation LLC · Milledgeville, GABuilt 2008 · S/N 262N1036S1036s LLC · Austin, TXBuilt 2005 · S/N 258704N103EZ103ez LLC · Champaign, ILBuilt 2011 · S/N 418N103TDTrigger Air LLC · Wilmington, DES/N 31-006N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305N108KNStuckey Connections LLC · Magnolia, TXBuilt 2007 · S/N 336N108RLShamrock Aero LLC · Liberty, NCBuilt 2003 · S/N 258619N109GXCfc LLC · Bloomington, INBuilt 2001 · S/N 142N109RCapital Air Sc LLC · Wilmington, DEBuilt 2008 · S/N HA-0076N10AZAnschutz Corp · Englewood, COBuilt 1999 · S/N 178N10JMov Aviation LLC · Wilmington, DEBuilt 2007 · S/N 337N10RZPeregrine Falcon LLC Trustee · Boise, IDBuilt 2008 · S/N 258N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190N110EXKm 900 LLC · Chesterfield, MOBuilt 2000 · S/N 71N111KRLs 464 LLC · Colorado Springs, COBuilt 1981 · S/N 464N111MDArgosy Aircraft Inc · Reno, NVBuilt 2007 · S/N HA-0035N112EDE D Santos & Associates LLC Trustee · Wilmington, DES/N 258048N115MF46 Aviation Holdings LLC · Gallatin, TNBuilt 2002 · S/N 330N115RJ7192 Locke Road LLC · Millington, TNBuilt 2004 · S/N 153N116PJForty Er LLC · Bethany, OKS/N 2027N117WHNobelstar Holdings LLC · Flower Mound, TXBuilt 2009 · S/N HA-0140N118DLN118dl LLC · Dover, DEBuilt 2003 · S/N 258607N118RKTaber Air LLC · Oklahoma City, OKBuilt 2006 · S/N 296N118UFUnited Fire & Casualty Co · Cedar Rapids, IABuilt 2011 · S/N HA-0183N11WMRegistered aircraftBuilt 1999 · S/N 58N120JWRedge Air LLC · Jacksonville, FLBuilt 2004 · S/N 258672N122LJBas Part Sales LLC · Greeley, COBuilt 1993 · S/N 258239N124GDDino Corporation LLC · Wilmington, DEBuilt 1998 · S/N 29N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067N125XPN125xp LLC · Wilmington, DEBuilt 2000 · S/N 258485N126BKAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2000 · S/N 068N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212N12VQDtm Aviation LLC · Statesboro, GABuilt 2007 · S/N 324N130YBMwl Aviation 1 LLC · Miami Lakes, FLBuilt 2002 · S/N 258590N1318AAnsaki Aviation LLC · Bloomfield Hills, MIBuilt 2008 · S/N HA-0078N131JXCbr Aviation LLC · Delaware, OHBuilt 2012 · S/N 450N132NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 438N133KSJyh Aviation LLC · Jacksonville, FLBuilt 2004 · S/N 258697N133VSVrs Holdings LLC · Medina, OHBuilt 2006 · S/N 2060N136MVTransnet Aviation Group LLC · Short Hills, NJBuilt 2001 · S/N 311N137BRCimarron Aviation LLC · El Paso, TXBuilt 2007 · S/N 45-2068N141ALAllete Enterprises Inc · Duluth, MNBuilt 2008 · S/N HA0055N141JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 2010N143LJBchjet3 LLC · Greer, SCS/N 143N145APKress Enterprises Inc · Brimfield, ILBuilt 2006 · S/N 300N145LRCalchem Transportation LLC · Stockton, CABuilt 2000 · S/N 119N145MWWhiskey Tango LLC · Midland, TXBuilt 2009 · S/N 400N145PJWeezerair LLC · Delray Beach, FLBuilt 2008 · S/N 383
Back to AD 2012-16-14