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.

N125ZUsda Forest Service · Boise, IDBuilt 2017 · S/N 100-0226N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250N126HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2014 · S/N 502B-2947N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595N126RFRandigo LLC · Wilmington, DEBuilt 2005 · S/N 208B1156N1276YJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1113N127ARAircraft Unlimited Inc · Pierre, SDBuilt 2004 · S/N 208B1055N127AXAlaska Central Express Inc · Anchorage, AKBuilt 1989 · S/N UC76N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312N127RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0350N12813Razor Aviation Corp · Kalispell, MTBuilt 2000 · S/N 208B0808N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87N128STJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1133N128WWSpears Aerial Crop Care LLC · Mamou, LABuilt 2011 · S/N 502B-2793N1296STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 208B1296N1296YPa1 208b-1079 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1079N129CGSchuman Carriage Co Ltd · Honolulu, HIBuilt 2007 · S/N 208B1290N129EJShelbyville Auto Sales LLC · Shelbyville, TNBuilt 2001 · S/N 4697065N129JWAir Methods LLC · Greenwood Village, COBuilt 1996 · S/N 129N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129N129LCL R & F LLC · Dover, DEBuilt 1979 · S/N 31T7904042N129TPHljh LLC · Corpus Christi, TXBuilt 2005 · S/N 629N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12N12LUDonalds Flying Service Inc · Pantego, NCBuilt 1998 · S/N T15-037DCN12MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 2024 · S/N 100-0342N12XVStormhaul Holding LLC · Taylors, SCBuilt 2021 · S/N 20800678N1314XWright Air Service Inc · Fairbanks, AKBuilt 2008 · S/N 208B1314N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225N131RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B-0851N131SAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 46020113N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131N131SPKauffman Land & Development LLC · Denver, COBuilt 1983 · S/N LA-206N1322TStrain Aviation LLC · Arbuckle, CABuilt 2015 · S/N 100-0135N1323YState Of Alaska · Anchorage, AKBuilt 2001 · S/N 20800352N1324GProps & Jets Inc · Dover, DEBuilt 1999 · S/N 208B0777N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132N132TJVertol Systems Company Inc · Destin, FLBuilt 2011 · S/N 173N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321N133KQValiair Lc Trustee · Casper, WYBuilt 2014 · S/N 100-0133N133RFRandigo LLC · Wilmington, DEBuilt 2000 · S/N 208B0840N134ME D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2003 · S/N 4697169N1350AAlaska Skypower LLC · Fairbanks, AKBuilt 1944 · S/N 33032N135CKStellar Aviation LLC · Williamstown, NJBuilt 1999 · S/N 208B0776N135FLAfdflt LLC · Mount Vernon, ILBuilt 2002 · S/N 4697135N135LTFleming William D · Litchfield, ILBuilt 1997 · S/N 135N135RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0551N13642Visser Ag Inc · Rigby, IDBuilt 1999 · S/N 502B-0598N136CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0037N1375FBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 402B-1375
Back to AD 2022-08-13