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.

N21212Sale Reported · Phoenix, AZSale reported, canceledBuilt 2007 · S/N 172S10441N2121FSouth Dakota State University · Brookings, SDBuilt 2007 · S/N 172S10437N2122MHalsted Aviation LLC · West Chicago, ILBuilt 2007 · S/N 172S10442N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905N21263Suburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9429N2126FVista Aviation Inc · Pacoima, CABuilt 2007 · S/N 172S10458N21276Schrager Daniel L Trustee · Concord, MABuilt 2003 · S/N 172S9433N2129CFlot Group LLC · Apex, NCBuilt 2003 · S/N 172S9436N2129JRidgeline Assets LLC · Wilmington, DEBuilt 2003 · S/N 172S9441N212BSEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8243N212CFWest Coast Equipment Leasing LLC · Englewood, COBuilt 1998 · S/N 17280418N2130FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2003 · S/N 172S9419N2132WWheeler Equipment Leasing LLC · Gainesville, GABuilt 2003 · S/N 172S9421N21339Pilots Flying School LLC · Englishtown, NJBuilt 2003 · S/N 172S9551N2134MChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9552N2135KJet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9556N2135SEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 172S9558N2138WChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9561N21394Long Island Aviators LLC · Seaford, NYBuilt 2007 · S/N 172S10449N2139UJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10448N213AAAir Mac Ventures LLC · Houston, TXBuilt 2007 · S/N 172S10511N213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12572N2141YAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 172S9562N2145JSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2003 · S/N 172S9418N2145TCff Air Inc · Wilmington, DES/N 17281174N21483Lima-001 LLC · Muscatine, IABuilt 2003 · S/N 172S9515N214GZAerospring Leasing LLC · Wasilla, AKBuilt 2005 · S/N 172S9862N2150GMsb Aviation LLC · Rockvale, TNS/N 172S9516N2152SMoore Aviation Inc · Beaver Falls, PABuilt 2003 · S/N 172S9444N2152VJameson Paul E · Palm Coast, FLBuilt 2003 · S/N 172S9445N2153AAcuna Edward DBA · Pearland, TXBuilt 2003 · S/N 172S9448N2154JLabrum Jack V · Prescott, AZBuilt 2003 · S/N 172S9451N2157HMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9536N2158SChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9539N21591Kohn Aviation LLC · San Carlos, CABuilt 2004 · S/N 172S9658N215CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13074N215HRLld Inc · Sarasota, FLBuilt 2003 · S/N 172S9527N215LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9215N2160DSamper Katherine · Miami, FLBuilt 2003 · S/N 172S9547N2160QSo Cal Leasing LLC · El Cajon, CAS/N 172S9546N21621Csa Aircraft Leasing LLC · Salt Lake City, UTS/N 172S9530N21627Beach David S Trustee · Amherst, NHBuilt 2004 · S/N 172S9575N21662Smedley Jonathan G · Leander, TXBuilt 2004 · S/N 172S9647N21670Kingsky Flight Academy LLC · Lakeland, FLBuilt 2004 · S/N 172S9709N2168DSpartan Education LLC · Tulsa, OKBuilt 2004 · S/N 172S9649N21692Knife Edge LLC · Daytona Beach, FLBuilt 2004 · S/N 172S9651N216CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13077N216LTWingsleasing LLC · Wichita, KSBuilt 1999 · S/N 172S8121N216SPNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1999 · S/N 172S8216N21705Bagamaspad Alan · Reseda, CABuilt 2004 · S/N 172S9699
Back to AD 2012-22-01