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.

N20704Atpce LLC · Wilmington, DES/N 172S12531N20707Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12562N20711Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12563N20727Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12577N20747Above And Beyond Aviation LLC · Austin, TXBuilt 2020 · S/N 172S12578N20773Smtm Holdings Inc · Wilmington, DEBuilt 2004 · S/N 172S9570N207CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13071N207SFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13485N20818N20818 LLC · Wilmington, DES/N 172S12579N2081JWings Over Texas Holdings LLC · Denton, TXS/N 17280995N2081SPlane Nonsense Inc · Middletown, DEBuilt 2005 · S/N 172S10023N20830Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12580N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671N20884Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12581N208CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12502N20910Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12582N20913Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12583N20957Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9571N2097GMountain Air Aviation LLC · Fruit Heights, UTBuilt 2004 · S/N 172S9662N2097TPatriot Aviation Inc · Greenville, DEBuilt 2004 · S/N 172S9585N2098AAtp Aircraft 1 LLC · Wilmington, DEBuilt 1999 · S/N 17280762N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204N209JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13008N209KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12826N20BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13216N20EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2020 · S/N 172S12513N20MVElizabeth City State University · Elizabeth City, NCBuilt 2018 · S/N 172S12143N20SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11623N2100SBietsch Aviation LLC · Dumfries, VABuilt 2004 · S/N 172S9589N21019Svetfur Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9595N21022Ameriflyers Of Texas Inc · Addison, TXBuilt 2004 · S/N 172S9660N2102PZima Aviation LLC · Huntington Beach, CABuilt 2004 · S/N 172S9594N2103TIasco Flight Training Inc · Redding, CABuilt 2004 · S/N 17281205N2104HGrenier Chad · Moorpark, CABuilt 2007 · S/N 172S10432N21056N21056 LLC · Wayne, PABuilt 2007 · S/N 172S10434N2105XAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12585N2107UFlight World Inc · San Juan, PRBuilt 2004 · S/N 172S9603N2108LSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2004 · S/N 172S9605N2108ZPinnacle Aviation Services Inc · Encinitas, CABuilt 2004 · S/N 17281207N2109LCaban-Loperena Jumil · Moca, PRBuilt 2004 · S/N 172S9609N210HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9040N210SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12431N2114QJet Air Inc · Iowa City, IABuilt 2004 · S/N 172S9616N2114UBravo Zulu Aviation LLC · Torrance, CAS/N 172S9618N21180L&W Leasing LLC · Murfreesboro, TNS/N 172S9624N2118LIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280676N2119EMid-Island Air Service Inc · Ronkonkoma, NYBuilt 2004 · S/N 17281212N2119QMustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9623N211FTUniversity Of The South · Sewanee, TNBuilt 2021 · S/N 172S12774N211TDChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8524
Back to AD 2012-22-01