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.

N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137N138JMFull Throttle Aviation LLC · Clayton, DEBuilt 1991 · S/N 7N139MCBilly Bobs Flying Service LLC · Bay, ARBuilt 2024 · S/N 510-139N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868N13GXEpic II LLC · Reno, NVBuilt 2023 · S/N K040N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590N13SUDownwind LLC DBA · Salt Lake City, UTBuilt 2009 · S/N 152N141DZLiam 750 Inc · Charlevoix, MIBuilt 2008 · S/N XL 150N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465N141RFRandigo LLC · Wilmington, DEBuilt 1986 · S/N 20800105N1421ZMng Leasing LLC · Bottineau, NDBuilt 1998 · S/N 140N142DVSalerno Robert J · Cornwall, NYBuilt 2015 · S/N 100-0142N142EEHound Dog Aircraft LLC · Lawrence, KSBuilt 2005 · S/N 4697217N143AUSkydive Guam Inc · Barrigada, GUBuilt 2005 · S/N 125N143ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1974 · S/N 437N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49N144JTFlight 1976 LLC · Kennesaw, GABuilt 1999 · S/N 144N144KSAas LLC · Ovid, MIBuilt 1986 · S/N 400-0640N1455TKenmore Air Harbor LLC · Kenmore, WAS/N 1647TB26N145GPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 20800722N145KAKamaka Air LLC · Honolulu, HIBuilt 2008 · S/N 208B2019N145SLCash Depot Ltd · Green Bay, WIBuilt 2004 · S/N 1093N145WAMartinaire Aviation LLC · Addison, TXBuilt 2005 · S/N 208B1145N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046N146SLDodson International Parts Inc · Rantoul, KSS/N 1091N146WMWatermakers Air Inc · Fort Lauderdale, FLBuilt 2000 · S/N 208B-0813N148SAZuni LLC · Kirkland, WAS/N 409N148SHBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 504-4044N149CCCianbro Corp · Baltimore, MDS/N FA-145N149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1996 · S/N 149N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149N149SHBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 504-4045N14GVScott T LLC · Portland, ORS/N 4697092N14RPAs350 LLC · Missoula, MTBuilt 2024 · S/N 100-0338N1500EVaughans Aircraft Leasing LLC · Claremore, OKS/N 402-0820N1502BAeroag LLC · Portland, INBuilt 1998 · S/N 502B-0476N1502UCentral Ag Air LLC · Marion, KSBuilt 1991 · S/N 502-0139N15054Air-Ag Inc · Tarboro, NCBuilt 1991 · S/N 402A-0823N15074Wells Flying Services LLC · Holdrege, NEBuilt 1991 · S/N 402A-0825N1507KDakota Air Spray LLC · Huron, SDBuilt 1991 · S/N 502-0142N150ACJohnson Airspray Inc · Argyle, MNBuilt 1991 · S/N T34-150N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531N150KReilly John P · Friendsville, PABuilt 2011 · S/N 100-0051N15102Moes Crop Dusting Service Inc · Marysville, CABuilt 1991 · S/N 502-0146N1515GKidd Clifford L · Monahans, TXBuilt 1991 · S/N 502-0152N15189Tri Rotor Spray & Chemical · Ulysses, KSBuilt 1991 · S/N 502-0155N1518ZMoss Jimmy David DBA · Tillar, ARBuilt 1991 · S/N 402-0837N1519ZFlatland Aviation LLC · Indianola, MSBuilt 1991 · S/N 502-0156N151BCBrc Az Aviation LLC · Scottsdale, AZBuilt 2020 · S/N 100-0289N151CAAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3653
Back to AD 2022-08-13