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.

N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601N194DDLcb Leasing · Bristow, VABuilt 2015 · S/N T20609194N194TWGreenway William Kendal · Greensboro, GABuilt 2014 · S/N T20609145N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312N1962GGr Aviation LLC · Key Biscayne, FLBuilt 2015 · S/N T20609159N1962KMria LLC · Albuquerque, NMBuilt 2013 · S/N T20609092N1968RCloud Transport Operations LLC · Albuquerque, NMS/N 21064375N196CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609136N196TTNbr Aviation · Bristow, VABuilt 2015 · S/N T20609196N196TWTango Lima Flying LLC · Lawrence, KSBuilt 2011 · S/N T20609019N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316N197WSObr Leasing · Bristow, VABuilt 2015 · S/N T20609197N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298N198RNKqm Aviation · Bristow, VABuilt 2015 · S/N T20609198N199PWJ & C Express Inc · Carbondale, ILBuilt 2017 · S/N T20609506N199TEPxw Services · Greenville, DEBuilt 2015 · S/N T20609199N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705N19LMM & M Skyshare LLC · Winter Park, FLBuilt 2024 · S/N T20609790N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629N1KPSherman Loren R Jr · Granbury, TXBuilt 1973 · S/N 21060006N1LQStrydom Cornelis F · Liberal, KSBuilt 1966 · S/N T210-0148N1SLHotel Kilo Aviation LLC · Anchorage, AKBuilt 1999 · S/N T20608051N200QRPdq Flight Inc · Garden City, NYS/N U20606092N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979N2012S9791m LLC · Tacoma, WAS/N 21060980N20135Africair Inc · Miami, FLBuilt 2025 · S/N T20609825N2019SMoore Bobby E · Perry, OKBuilt 1975 · S/N 21060987N2028SScherler Burl M · Sheridan Lake, COBuilt 1975 · S/N 21060996N202MCBeemer Companies · Fairmont, MNBuilt 2011 · S/N T20609030N2037SRubyco Inc Trustee · Wilmington, DEBuilt 1975 · S/N 21061005N2038SHatch Family Limited Partnership · Winslow, AZBuilt 1975 · S/N 21061006N2042SGausman Grace K · Lompoc, CABuilt 1975 · S/N 21061009N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013N204JHLivin The Dream Too LLC · St Paul, MNBuilt 2006 · S/N T20608638N204RSKenai Peninsula Air Transportation & Lodging LLC · Lake Havasu, AZBuilt 2011 · S/N T20609029N204TSAs The Crow Flies Aerial Services LLC · Irving, TXBuilt 1977 · S/N U20604052N2050SDavis Bryan C · Winfield, KSBuilt 1975 · S/N 21061017N2055QJones Jeff A · Lewiston, IDBuilt 1975 · S/N U20602965N2056SAcevedo Adriel · San Antonio, TXBuilt 1975 · S/N 21061023N2059U5c Valley Aviation LLC · Sun Valley, IDS/N T20608701N2061Ramos Sammy · San Juan, PRBuilt 2022 · S/N T20609710N20617Mtnairpower LLC · Santa Barbara, CABuilt 2017 · S/N T20609522N2064FMicrowave Rental LLC · Beaufort, SCBuilt 2022 · S/N T20609687N2064PPrivitt Bret · Hudson Oaks, TXBuilt 2023 · S/N T20609734
Back to AD 2012-10-52