AD 2012-10-52

Registered aircraft · 2,750

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-52')
    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-52')
  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.

N2378XState Of Utah · Salt Lake City, UTBuilt 1999 · S/N T20608023N2378YLindsey Aviation Services · Haslet, TXBuilt 1999 · S/N T20608025N2379FWebster Douglas Clark · Las Vegas, NVBuilt 1999 · S/N T20608019N2381YInvictus Investments LLC · Urbandale, IABuilt 1999 · S/N T20608018N2383LNebraska State Patrol · Lincoln, NEBuilt 2007 · S/N T20608769N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263N2389GMacon Septic Systems Co Inc · Macon, MSBuilt 2006 · S/N T20608586N2389LCjw Holdings LLC · Stamping Ground, KYBuilt 2000 · S/N T20608255N238TLLow Sean · Midland, TXBuilt 2012 · S/N T20609054N2391EInnova Energy LLC · Wilmington, DEBuilt 1999 · S/N T20608115N23HBHotel Bravo Aviation LLC · Houston, TXFirst renewal noticeBuilt 1977 · S/N 21062050N23VMOrange Skies LLC · Great Falls, VABuilt 2018 · S/N T20609533N2400TAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 2000 · S/N T20608160N240CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N T20609069N240PSN240ps LLC · Mesa, AZBuilt 2012 · S/N T20609081N240TBN54za LLC · Houston, TXBuilt 2024 · S/N T20609742N241MPGv Air Inc · Medford, ORBuilt 2011 · S/N T20609035N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276N24287J B C Development LLC · Evans, GAS/N T20608605N24293Digitalev LLC · Westminster, COBuilt 2006 · S/N T20608608N2429RJones Adam · Fairbanks, AKBuilt 2000 · S/N T20608161N242TC182 Flight Corp · Bronx, NYBuilt 2005 · S/N T20608530N242TJMagee Timothy I · Gulfport, MSBuilt 2022 · S/N T20609706N242VPirshafiey Nasser Charles · Trabuco Canyon, CABuilt 1965 · S/N T210-0004N242WBUnited States Department Of Interior · Boise, IDBuilt 2011 · S/N T20609037N24301Pacific Coast Cycle Corp · Kings Beach, CABuilt 1999 · S/N T20608139N2430QBeavercat Air LLC · Myrtle Point, ORBuilt 2006 · S/N T20608610N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782N243RZBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1983 · S/N 21064961N2440PN2440p LLC · Seattle, WABuilt 1999 · S/N T20608136N2440VVehrs Roger K · Roseburg, ORBuilt 2000 · S/N T20608176N2441GTognoli Stefano F · Union, ORBuilt 2000 · S/N T20608173N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284N2441YTag Aviation LLC · Santa Teresa, NMBuilt 2000 · S/N T20608169N2446ESugarloaf Air LLC · Wilmington, DES/N T20608580N244MEEagle Forestry Services Inc · Monticello, ARS/N T20608192N24507Pena Jairo · Catharpin, VABuilt 1999 · S/N T20608038N24518Fly Arkansas LLC · Harrison, ARS/N T20608236N2451A722jc LLC · Tyler, TXS/N T20608758N2451YSalmon Michael J Trustee · Albuquerque, NMBuilt 2007 · S/N T20608759N2453SFilipponi-Thompson Drilling Inc · Atascadero, CABuilt 1976 · S/N 21061294N2455XRucker Aviation Logistics Inc · Shingle Springs, CABuilt 1999 · S/N T20608121N24569Pt Logistics LLC · Rye, NHBuilt 2000 · S/N T20608209N2456HPappusgrass Aviation LLC · San Antonio, TXBuilt 1999 · S/N T20608124N2456LNew West Ventures II Inc · Rancho Santa Fe, CAS/N T20608272N245BTMichael Knapp · Galveston, TXBuilt 2025 · S/N T20609804N24607Fey Properties LLC · Pleasanton, CABuilt 2001 · S/N T20608277N2461FDietz Thomas · Mill Valley, CABuilt 1999 · S/N T20608119N2464CCantera La Rita Inc · San Juan, PRBuilt 2005 · S/N T20608584
Back to AD 2012-10-52