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.

N21706Spinks Flight Center Inc · Burleson, TXBuilt 2007 · S/N 172S10470N21714Aero Equities LLC · Ventura, CABuilt 2007 · S/N 172S10471N21718Blomgren David · Phoenix, AZBuilt 2004 · S/N 172S9645N2171XGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2004 · S/N 172S9655N2173ZTegridy Equipment Leasing LLC · Aurora, ORBuilt 2004 · S/N 17281216N21778Nodak Aircraft Leasing LLC · Fargo, NDBuilt 2007 · S/N 172S10483N217EPEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeBuilt 2017 · S/N 172S12006N2183JMichael Nehring Inc · Mohall, NDBuilt 2004 · S/N 172S9631N219CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13080N219SPLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1999 · S/N 172S8219N21LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8936N21SZVista Air Inc · Pacoima, CABuilt 1998 · S/N 17280653N2202QLewis University · Romeoville, ILBuilt 2007 · S/N 172S10517N22055Adrian Ojeda Jr · San Ysidro, CAS/N 17280902N220CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13256N220CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13046N220WCJeffery & Weiss Holdings LLC · Long Beach, CAS/N 172S10519N221EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12621N221MEKarabin Gerald D · Vicksburg, MIBuilt 2000 · S/N 172S8481N2221RPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1998 · S/N 17280681N22237Aviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S10025N2225AFreedom Aviation Inc · Lynchburg, VABuilt 2007 · S/N 172S10467N2225FTextron Aviation Inc · Wichita, KSBuilt 2007 · S/N 172S10468N22265Edb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S10026N222DCTextron Aviation Inc · Wichita, KSS/N 18283364N222LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8919N2235VE & R Aviation Services Inc · Long Beach, CABuilt 2007 · S/N 172S10478N223APJuliet Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13440N223BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280950N223CKBounds Keith A · Thomson, GABuilt 2004 · S/N 172S9580N223HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 17281112N223LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9223N2241VEdwards John D · Yardley, PABuilt 2007 · S/N 172S10481N22467Mustang Sally Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10487N224MAAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8613N224VSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12893N2254URaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280684N225RARochester Air Center LLC · Canandaigua, NYBuilt 2005 · S/N 172S9803N225SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13441N225TFTop Flight Aviation Inc · Corona, CABuilt 2004 · S/N 172S9755N225WCBozeman Skyhawk LLC · Bozeman, MTBuilt 2006 · S/N 172S10272N225WSSpartan Education LLC · Tulsa, OKBuilt 2005 · S/N 172S9800N2268AAerofeather Aviation Inc · Suffolk, VABuilt 1998 · S/N 17280686N226AVN286sa LLC · Manassas, VABuilt 2007 · S/N 172S10651N226EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13513N2272CBartow Municipal Airport Development Authority · Bartow, FLBuilt 2005 · S/N 172S9954N2272VGryffin Ventures LLC · Jupiter, FLBuilt 2000 · S/N 17280839N2274BAon-Adharc Aircraft Leasing LLC · Sellersburg, INBuilt 1999 · S/N 17280689N2277TEngisys Traffic LLC · North Potomac, MDBuilt 2005 · S/N 172S9958N227BHPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10662
Back to AD 2012-22-01