OpenAirDocs.org
AD 2022-08-13

Registered aircraft · 3,069

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-08-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:2022-08-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.

N108TFWood Flying Inc · Panhandle, TXBuilt 2008 · S/N 502B-2652N1095WEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1456N109CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0060N109MDM B Duncan Inc · Bakersfield, CABuilt 1985 · S/N BB-1213N109MSCavallino Rampante Inc · Dover, DEBuilt 1991 · S/N 1008N109WTJe Kodiak 2018 LLC · Edina, MNBuilt 2018 · S/N 100-0246N10BBFayard Enterprises LLC · Wake Forest, NCBuilt 1989 · S/N 20800152N10DHVta Capital LLC · Ontario, CABuilt 1981 · S/N LA-111N10EAEagle Air Transport Inc · Ottawa, ILS/N 199N10JAAircraft Structures International Corp · Enid, OKBuilt 2002 · S/N 208B0961N10STGocc Blue Sky LLC · Augusta, GABuilt 2005 · S/N 4697220N10WG10wg LLC · Newman Lake, WABuilt 1978 · S/N LW-310N10YPBmf Jax LLC · Jacksonville, FLBuilt 2020 · S/N 20800666N1103GMcn-Air LLC · Macon, GABuilt 1997 · S/N LJ-1475N110PEMission Aviation Fellowship · Nampa, IDBuilt 2000 · S/N 208B0858N110PMCcp Air LLC · Norwalk, OHBuilt 1997 · S/N LJ-1481N1110KPeach Air Corporation · Wilmington, DEBuilt 1997 · S/N LJ-1486N1114AEvans David J · Parker, COS/N 208B0309N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559N1114ZCarefree Air LLC · San Jose, CABuilt 1998 · S/N LJ-1514N1115MPa1 208b-0356 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0356N1116GAircraft Structures International Corp · Enid, OKBuilt 1994 · S/N 208B0402N1116WAvion Capital Corp · Anchorage, AKBuilt 1994 · S/N 208B0411N1117GBrylee Investment Corp · Wilmington, DEBuilt 1993 · S/N 208B0370N1119VMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0383N111AABlue Water Aviation LLC · Vestavia, ALS/N LA-6N111MQBismarck Air Medical LLC · Bismarck, NDBuilt 1999 · S/N BB-1665N111MZCrb Companies LLC · Tulsa, OKBuilt 1998 · S/N FL-210N111RFEaston Air LLC · Middletown, RIBuilt 2003 · S/N 259N111VRDftf LLC · Des Moines, IABuilt 1991 · S/N 1006N1120WMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0388N1126JBbc Air LLC · Macon, GABuilt 1997 · S/N LJ-1483N1128LArne Aviation LLC · Suffolk, VABuilt 1996 · S/N 208B0536N1129GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0924N112HBRegistration Pending · Holdrege, NERegistration pendingBuilt 2012 · S/N 502B-2825N112KQRondarosa Skybus LLC · Grangeville, IDBuilt 2014 · S/N 100-0112N112LTNorthrop Grumman Systems Corp · El Segundo, CABuilt 2003 · S/N 208B1037N1130JN1130j LLC · Huntsville, TXBuilt 1997 · S/N LJ-1467N1132FUS Government · Washington, DCBuilt 1999 · S/N 208B0741N113RFRandigo LLC · Wilmington, DEBuilt 1998 · S/N 208B0654N114BAAustin Bill DBA · Sparta, TNS/N 42-8001027N114JPJohnson Airspray Inc · Argyle, MNS/N T34-033N114PHPacific Air Holdings LLC · Shawnee, OKBuilt 2008 · S/N 208B2021N114RFRandigo LLC · Wilmington, DEBuilt 1998 · S/N 208B0677N114WLThompson Flying Service LLC · Charleston, MOBuilt 2014 · S/N 502B-2960N1154FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 208B1065N115CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0011N115CTChastang Lawrence · Orlando, FLBuilt 1999 · S/N BB-1669N115LABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 402B-1152N115PHPacific Air Holdings LLC · Shawnee, OKBuilt 2008 · S/N 208B2048
Back to AD 2022-08-13