AD 2012-10-13

Registered aircraft · 13,306

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-10-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:2012-10-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.

N46HDPrice Jesse · Fargo, NDBuilt 2005 · S/N 42071N46JGKslt Aviation LLC · Birdsboro, PABuilt 2022 · S/N 8814N46KVPigs Aviation LLC · Houston, TXBuilt 2021 · S/N 5130N46LAMagoon Paul J · Merrimack, NHBuilt 1986 · S/N 46-8608055N46MGHughes Shaun · Everett, WABuilt 1988 · S/N 4608136N46MRDavin Matthew · Ridgecrest, CABuilt 1975 · S/N 21060778N46MVTazzo Jet Services LLC · Jacksonville, FLBuilt 2021 · S/N 2275N46PAAyer William S · Bellevue, WABuilt 1984 · S/N 46-8408060N46PCMace Robert C Jr · Gold Canyon, AZS/N 21060105N46TESerenity Aero LLC · Cape Girardeau, MOBuilt 2005 · S/N 1694N46TLHayes Tony George · Baton Rouge, LABuilt 2015 · S/N L2K-312-1N46TRWingnerds LLC · Waukesha, WIBuilt 2010 · S/N 0043N46WBBullen Riley P · Kingman, AZBuilt 2000 · S/N 29-0226N46ZELitton Enterprises Inc · Incline Village, NVBuilt 2018 · S/N 1790N4701AWtfa LLC · Decatur, ALBuilt 1978 · S/N 414A0085N470BCCorvus Flight LLC · Salinas, CABuilt 1977 · S/N 414-0918N470CDPrecision Machine Tool Solutions LLC · Sinking Spring, PABuilt 2005 · S/N 1611N470STLima Charlie 2.0 LLC · Duluth, GABuilt 2025 · S/N 10545N4712KMclellan Bruce A Trustee · Bend, ORBuilt 1979 · S/N P21000262N4714CGorman Aviation LLC · Bartlesville, OKBuilt 1979 · S/N 21063596N4715WKelley Christopher L · La Quinta, CABuilt 1980 · S/N P21000624N4716XJessup Sheila · Dublin, CABuilt 1980 · S/N U20605527N4717CCt Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 21063598N471FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10471N471HBMyers Ralph E · San Clemente, CABuilt 1977 · S/N 414-0923N471MASwift Aviation LLC · Decatur, TNBuilt 1979 · S/N 414A0279N471WMRegistered aircraftBuilt 2011 · S/N 3801N4720CNesbit Gary M · West Linn, ORBuilt 1979 · S/N 21063601N4720PKlingler Larry R · Wolfeboro, NHBuilt 1978 · S/N P21000090N4720YKraemair Aviation LLC · Sauk City, WIBuilt 1980 · S/N 21063992N4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 21063993N4726YMeisner David B · Meridian, IDBuilt 1980 · S/N 21063994N4729CSullivan David C · St George, UTBuilt 1979 · S/N 21063604N472AGTzc LLC · Lafayette, INBuilt 2021 · S/N 2408N472CDLorton Kenneth Patrick · Brooklyn, NYBuilt 2004 · S/N 1197N472DVEleven A Inc Trustee · Wilmington, DEBuilt 2024 · S/N 9836N472JJCirrus Design Corp · Knoxville, TNBuilt 2019 · S/N 1889N472KEB Rex LLC · East Palo Alto, CABuilt 2019 · S/N 4781N472MBSimmons Jeffrey F · Houston, TXBuilt 2024 · S/N 10166N472PLRiviera Aero Sales Inc · Santa Barbara, CABuilt 2026 · S/N 11133N472SRJuice Club Air LLC · Palm Springs, CABuilt 2006 · S/N 2272N4735PMarchman & Assosiates Inc · Krum, TXS/N P21000092N473BCWaite Aviation LLC · Xenia, OHS/N 1658N473BJValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 3700N473CDGrupinski Stephen · Wimberley, TXBuilt 2005 · S/N 1564N473MBProestakis Mijali N · Cypress, TXBuilt 2023 · S/N 9295N473PRomeo Mike Properties LLC · Naples, FLBuilt 2021 · S/N 2244N4741KCrosswind Solutions Inc · Medford, ORBuilt 1979 · S/N P21000272N4742UProtocol Enterprises LLC · Holdrege, NEBuilt 1983 · S/N 21064810N4743CFour Three Charlie LLC · Andover, MABuilt 1979 · S/N 21063608
Back to AD 2012-10-13