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.

N1715LValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N T20608788N1717XSay Plastics Inc · Jacksonville, TXBuilt 1967 · S/N T2100267N171BCR Wesley Aviation LLC · Chandler, AZBuilt 1981 · S/N 64251N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894N1727LTexas Department Of Public Safety · Austin, TXFirst renewal noticeBuilt 2007 · S/N T20608791N1728LCaldwell Clifton M · Sterling City, TXBuilt 2007 · S/N T20608776N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735N17386Oregon State Police · Salem, ORBuilt 2007 · S/N T20608800N1740LMidsouth Marketing Inc · Colt, ARBuilt 2007 · S/N T20608784N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763N1746LNebraska State Patrol · Lincoln, NES/N T20608809N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666N174STMichigan State Police · Lansing, MIBuilt 2003 · S/N T20608400N1756LSan Sophia LLC · West Linn, ORBuilt 2009 · S/N T20608920N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739N176CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T20609001N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744N1786XS K Cattle Co · Manhattan, KSBuilt 1975 · S/N 21060806N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445N179DMNg Research · Bristow, VABuilt 2015 · S/N T20609179N179MEFlight Rt LLC · Thonotosassa, FLBuilt 2000 · S/N T20608184N17BBTextron Aviation Inc · Wichita, KSS/N T20609861N180KHPwx Services · Bristow, VABuilt 2015 · S/N T20609180N1812QLiv2fly LLC · Grand Junction, COBuilt 1975 · S/N U20602936N1815HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 21061148N181MECoastal Marine Engine Inc · Seattle, WABuilt 2000 · S/N T20608182N181PKPacific Mission Aviation · Hagatna, GUFirst renewal noticeS/N U20606158N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408N18260Atc Trucking Inc · Miami, FLBuilt 2005 · S/N T20608543N1834UWirth Rodney A · Greenwood, ARBuilt 2005 · S/N T20608546N184SGNby Productions · Bristow, VABuilt 2015 · S/N T20609184N185BKSfh Inc · Fargo, NDBuilt 2018 · S/N T20609555N185KPNg Research · Bristow, VABuilt 2015 · S/N T20609185N18691869 Leasing LLC · Aurora, ORBuilt 2008 · S/N T20608802N186MLIdaho Fly Girl LLC · Boise, IDBuilt 1974 · S/N U20602644N187DHPsl Surveys · Bristow, VABuilt 2015 · S/N T20609187N188AGRvest Management LLC · Boulder City, NVBuilt 1999 · S/N T20608039N188CSJaae Inc · North Miami Beach, FLBuilt 2014 · S/N T20609118N188SSNby Productions · Bristow, VABuilt 2015 · S/N T20609188N189CBOtv Leasing · Bristow, VABuilt 2015 · S/N T20609189N189JCTulare County Sheriff · Visalia, CABuilt 2017 · S/N T20609510N189JMJsc Rentals LLC · Missoula, MTS/N T20608782N190PDCommonwealth Of Puerto Rico Policia Of Puerto Rico · San Juan, PRBuilt 2015 · S/N T20609161N191MBFvx Research · Bristow, VABuilt 2015 · S/N T20609191N1922TBiscoe Donald M · Cottage Grove, MNBuilt 1969 · S/N 21059220N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160N192WBPsl Surveys · Bristow, VABuilt 2015 · S/N T20609192N193GMRkt Productions · Bristow, VABuilt 2015 · S/N T20609193
Back to AD 2012-10-52