AD 2012-22-01

Registered aircraft · 3,852

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:2012-22-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-01')
  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.

N197BALewis University · Romeoville, ILBuilt 1997 · S/N 17280314N197MCLewis University · Romeoville, ILBuilt 2006 · S/N 172S10197N197MEPremier Air Of Delaware Inc · Flemington, NJBuilt 2000 · S/N 172S8472N197TACoast Aviation LLC · Costa Mesa, CABuilt 2002 · S/N 172S9197N198BWFixed Wing Holding Co Inc · Pembroke Pines, FLS/N 17280382N198MECal Aggie Flying Farmers · Davis, CABuilt 2000 · S/N 172S8473N198PGSun City Aviation LLC · Davie, FLBuilt 2001 · S/N 172S8851N198SPFlight Training Aircraft LLC · Wilmington, DEBuilt 2003 · S/N 172S9465N198THWingsleasing LLC · Wichita, KSBuilt 2015 · S/N 172S11554N1998FSpartan Education Group LLC · Tulsa, OKBuilt 1998 · S/N 17280347N1998RA & E Flying Club Of Los Angeles Inc · Hawthorne, CABuilt 1998 · S/N 17280389N199SPW Air LLC · Wheeling, ILBuilt 2003 · S/N 172S9467N19MVSky Path Aviation LLC · Sheridan, WYBuilt 2019 · S/N 172S12273N2000CTextron Aviation Inc · Wichita, KSS/N 172S13601N2004UEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13449N20067Epic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13448N2007XEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13447N2012FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13452N2013WEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13451N2016FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13450N201ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13545N201FSRegistration Pending · Peoria, AZRegistration pendingBuilt 2000 · S/N 172S8453N201KSKing Aircraft LLC · San Diego, CABuilt 2019 · S/N 172S12251N201THG & M Aircraft Inc · Wheat Ridge, COBuilt 1997 · S/N 17280201N201TWTom Wood Aviation Inc · Fishers, INBuilt 2025 · S/N 172S13294N201WLWingsleasing LLC · Wichita, KSBuilt 2026 · S/N 172S13570N202AJEnterprise Aviation Services LLC · Albuquerque, NMBuilt 2007 · S/N 172S10450N202CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12334N2030CSky Bear LLC · Lakewood, CABuilt 2005 · S/N 172S9941N203CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12501N203KSMichael Lichtman Inc · Oceanside, CAFirst renewal noticeBuilt 2001 · S/N 172S8856N20401Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12519N20412Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12520N20417Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12522N20422Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12523N20425Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12524N2046KChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12092N20502Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12525N20519Skyhawk Leasing LLC · Mccordsville, INBuilt 2004 · S/N 172S9576N2052VBlue Sky Personnel Services LLC · Coushatta, LABuilt 2004 · S/N 172S9583N20537Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12526N20549Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12527N2054SLewis University · Romeoville, ILBuilt 2004 · S/N 17281203N2055RWnc Aviation LLC · Arden, NCBuilt 2004 · S/N 172S9581N20564Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12528N20566Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12530N20597Hk Aircraft Leasing LLC · Lititz, PABuilt 2005 · S/N 172S9947N205FGRidgeline Assets LLC · Wilmington, DEBuilt 2017 · S/N 172S12093N205HCGulf Coast Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S10003N2060UJade Air LLC · Lomita, CABuilt 2005 · S/N 172S9952
Back to AD 2012-22-01