OpenAirDocs.org
AD 2016-07-13

Registered aircraft · 37

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-07-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-07-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.

N12NTNovember Tango LLC · Ketchum, IDBuilt 2005 · S/N LIV-566N193CGLeading Edge Air LLC · Highlands Ranch, COBuilt 2009 · S/N LIV-487N212JCMatrix Sea Air And Land Brokerage LLC · Hypoluxo, FLS/N 045N293RGVintage Aero Collection Inc · Wilmington, DEBuilt 2006 · S/N LIV-269N357AVVasenden Arnold · Midlothian, TXBuilt 2020 · S/N 9205N3644YRainbow Sports Inc · Enid, OKBuilt 2005 · S/N LIV-554N3WQSymbiotic Assets LLC · Winnemucca, NVBuilt 2004 · S/N 048SS52728N401KREast Air Aviation LLC · Cullman, ALBuilt 1991 · S/N 401-0813N401NEBender Jace Edwin Fredrick · Humphrey, NEBuilt 1994 · S/N 401B0960N486EAKamikaze Air LLC · Lake Mary, FLBuilt 2016 · S/N 115N51AROlsem Aerial Application Services LLC · Westbrook, MNBuilt 1970 · S/N 1523RN532NCDiscover Resources LLC · Norman, OKBuilt 2003 · S/N LIV-532N54XESaxe Michael · College Station, TXBuilt 2025 · S/N L-IV-PT-511N555XTTriple Five Air LLC · Sioux Falls, SDBuilt 2013 · S/N LIV-324N5UCR V Stich Construction Inc · Richmond, CABuilt 2004 · S/N LIV-524N601PFPernell Andrew B · Meridian, IDBuilt 2004 · S/N LIV-503N6116AGollott Dale A · Biloxi, MSBuilt 2001 · S/N 008237N63EAvag Inc · Richvale, CABuilt 1977 · S/N 305BN661CMBristol Bay Capital Partners Inc · King Salmon, AKS/N LIV-538N666EXSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2016 · S/N BUEX0001N682KALott Dalton Leon · Duncanville, TXS/N LJ-682N703THMunich Hans W DBA · Yakutat, AKBuilt 1966 · S/N 456N747TFMkm LLC · Anchorage, AKBuilt 2003 · S/N 111TN750ALLane Ashley C · Lakeland, GABuilt 1973 · S/N 1799RN750BTN750bt LLC · Crested Butte, COBuilt 2004 · S/N 4229N750DLSteve Jackson Racing LLC · Helena, MTBuilt 2003 · S/N 001N751WCValley Spraying Service LLC · Gann Valley, SDBuilt 1989 · S/N R1820033N753MVita Clean Services Inc · Wenatchee, WABuilt 2005 · S/N LIV-507N773DCe-Air Inc · Argyle, IABuilt 1985 · S/N 773BN777DGBlue Chip Enterprises Inc · Clayton, NCBuilt 2010 · S/N LIV-452N821DLCrockett Donald Richard · Artesia, NMBuilt 2004 · S/N 037SLX904N845XCentral Copters Inc · Bozeman, MTBuilt 2006 · S/N 0585206N89NWCommon Cents Holding Company LLC · Memphis, TNBuilt 2005 · S/N LIV556N911EEUtt LLC · Missoula, MTBuilt 2005 · S/N LIV 550N9152FHatfield Spraying Service Inc · Nunica, MIBuilt 1989 · S/N R1340017N9214MKoo Carlos · Atherton, CABuilt 2005 · S/N LIV-567N9XWAerotica LLC · Fleming Island, FLBuilt 2004 · S/N LIV-528
Back to AD 2016-07-13