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.

N115TTNo Delay LLC · Tickfaw, LABuilt 1992 · S/N FL-74N115WATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1964 · S/N 110451N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772N117BBKustatan Leasing LLC · Nikiski, AKBuilt 1962 · S/N 1511N117CWestern Enterprise LLC · Pueblo, COBuilt 1996 · S/N LJ-1433N117EGFcs Aircraft Inc Trustee · Wilmington, DEBuilt 2014 · S/N 100-0117N117EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-114N117NURegistered aircraftBuilt 1998 · S/N 4636138N117PWCommand Air LLC · Arlington, VABuilt 2001 · S/N 4697030N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17N1188G207rs LLC · Santa Feon, NMBuilt 1984 · S/N 425-0202N118AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 468508019N118KTKranze Technology Solutions Inc · Des Plaines, ILBuilt 2004 · S/N 208B1077N118RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0574N118SBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1541N119QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 119N119RFRandigo LLC · Wilmington, DEBuilt 2002 · S/N 208B0929N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502N11DGAir Grace LLC · Blanco, TXBuilt 2024 · S/N K060N120KQMission Aviation Fellowship · Nampa, IDBuilt 2014 · S/N 100-0120N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9N120WWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 4697047N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243N12155International Air Services Inc Trustee · Carson City, NVBuilt 1996 · S/N 208B0562N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336N121HARedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0069N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520N121TDRegistration Pending · Montgomery, ALRegistration pendingBuilt 1979 · S/N 78-23138N1222BKelly Douglas E · Bethesda, MDBuilt 1980 · S/N 425-0060N1224WMaco Aviation Inc · Dayton, WABuilt 1998 · S/N 502A-0496N1229CKalinin Partners LLC · Juneau, AKBuilt 1996 · S/N 208B0589N1229XTalkeetna Aero Services Inc · Anchorage, AKBuilt 1992 · S/N 20800212N1229ZKalinin Partners LLC · Juneau, AKBuilt 2002 · S/N 208B0943N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122N1232YPa1 208b-0566 LLC · Fort Lauderdale, FLBuilt 1996 · S/N 208B0566N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655N123FXFreefall Express · Gardiner, NYBuilt 1969 · S/N 200N123KQValiair Lc Trustee · Casper, WYBuilt 2009 · S/N 100-0013N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587N1242YSkydive Baltimore LLC · Lincoln, DEBuilt 2002 · S/N 208B0939N124EBPremium Air LLC · Hibbing, MNBuilt 1995 · S/N FL-126N124RFRandigo LLC · Wilmington, DEBuilt 1988 · S/N 20800018N1258BSouthern Airways Pacific LLC · Addison, TXBuilt 2007 · S/N 208B1258N125RFRandigo LLC · Wilmington, DEBuilt 2012 · S/N 208B2330N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422
Back to AD 2022-08-13