OpenAirDocs.org
AD 2022-13-16

Registered aircraft · 36

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:2022-13-16')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-13-16')
  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-566N151PKN63e LLC · Fallon, NVBuilt 2008 · S/N 028N173JDiemert Flying LLC · Roseburg, ORBuilt 2021 · S/N LIV-574N212JCMatrix 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 048SS52728N486EAKamikaze 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-532N555XTTriple 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-682N747TFMkm LLC · Anchorage, AKBuilt 2003 · S/N 111TN750BTurbine Power Nv LLC · Helena, MTBuilt 2016 · S/N LIV-245N750BTN750bt LLC · Crested Butte, COBuilt 2004 · S/N 4229N750DLSteve Jackson Racing LLC · Helena, MTBuilt 2003 · S/N 001N753MVita Clean Services Inc · Wenatchee, WABuilt 2005 · S/N LIV-507N777DGBlue Chip Enterprises Inc · Clayton, NCBuilt 2010 · S/N LIV-452N77JKAmeriflight Management Services · Orlando, FLBuilt 2011 · S/N 101N815NSN815ns LLC · Dover, DES/N LIV-430N821DLCrockett Donald Richard · Artesia, NMBuilt 2004 · S/N 037SLX904N825BAGazelle Helicopters Inc · San Luis Obispo, CABuilt 2005 · S/N 01N840FMendive Richard J · Priest River, IDBuilt 2006 · S/N RH5000100N89NWCommon 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-567N95007Velocity Air LLC · Livermore, CABuilt 2007 · S/N 118TMN9XWAerotica LLC · Fleming Island, FLBuilt 2004 · S/N LIV-528
Back to AD 2022-13-16