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.

N533TJTmc Plane LLC · Bluffton, SCBuilt 2015 · S/N 4292N533WPJacobs Aviation LLC · Mt Juliet, TNS/N 340A0328N5340GLegal Limit Motor Sports LLC · Anderson, CAS/N 340A0421N5340WHebel Ryan · North Potomac, MDBuilt 1981 · S/N P21000675N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173N5346JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 340A0419N5347WAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1955 · S/N G275N5348MLooney Tunes Air LLC · Omaha, NEBuilt 2004 · S/N 0792N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176N5349B39 Bravo LLC · Wilmington, DEBuilt 1988 · S/N E-2416N534CDAdvanced Tree Care Inc · Lincolnshire, ILBuilt 2005 · S/N 1623N534CPOn Duty Health - Texas Pllc · Redlands, CABuilt 2008 · S/N 3035N534DMBarnstorm/T-34 LLC · Jacksonville, FLBuilt 1955 · S/N G-750N534SRArrowhead Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 1079N53511Didia Robert · Fraser, MIBuilt 2004 · S/N 0864N53512Rapp Steven B · Hawthorne, CABuilt 2004 · S/N 0868N5358UMadson Chris · King City, CABuilt 1984 · S/N 21064877N5359APalo Duro Aircraft Services Lc · Mckinney, TXBuilt 1979 · S/N 21063388N535CCrystal John · Las Vegas, NVBuilt 1998 · S/N 29-0146N535CCRiley Aviation LLC · Eden Prairie, MNBuilt 2019 · S/N 1859N535CRScs Assets LLC · Ponce, PRBuilt 1979 · S/N 414A0244N535CSLevel Flight II LLC · Rockledge, FLBuilt 2021 · S/N 2466N535GGResearch Insight LLC · Laguna Beach, CABuilt 2021 · S/N 2291N535JProctor Patrick Alan Jr · Hoover, ALS/N 0265N535LBJet Quest LLC · West Palm Beach, FLS/N 2873N535MESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000345N535PGSs Aviation LLC · Westlake, LABuilt 2005 · S/N 1293N535RFlight Training Pro LLC · Nashville, TNBuilt 2005 · S/N 29-0381N535RTN535rt LLC · Provo, UTS/N 0407N535SCardoza Real Estate Inc · Eagle, IDBuilt 2001 · S/N 0014N5362AFerguson Lynn D · Alpine, WYBuilt 1979 · S/N 21063391N5365XSale Reported · Greeley, COSale reportedBuilt 1973 · S/N 414-0387N5368AValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 21063394N5369YPollard William Edward · Big Spring, TXBuilt 1980 · S/N 21064185N536AJP3 Aviation LLC · Nashville, TNBuilt 2010 · S/N 3579N536CAMayer Gordon · Dallas, TXBuilt 2026 · S/N 11211N536CPRegistration Pending · Mountain Green, UTRegistration pending, pending cancellationS/N 3036N536JSShoffner James P Jr · Denver, COBuilt 1984 · S/N EA-418N536KEngage Helicopters LLC · Sarasota, FLS/N E3220N536PSky High II LLC · Clinton, NCBuilt 1998 · S/N E3197N536PCMr. Goodcents Leasing Systems Inc · De Soto, KSBuilt 2006 · S/N 1763N536WWright Jack · Fortson, GABuilt 2002 · S/N E-3458N5372CFlc Aviation LLC · Dyersburg, TNBuilt 1978 · S/N 414A0110N5372SFlying Solo LLC · Omro, WIBuilt 2004 · S/N 0816N5378PBlue Skies Today LLC · Eagan, MNBuilt 1974 · S/N U20602492N537ABHemmati Joshua · Lake Oswego, ORBuilt 2016 · S/N 4332N537CDSullivan Scott W · Sandy, ORBuilt 2005 · S/N 1388N537CPRegistered aircraftBuilt 2008 · S/N 3038N537FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10537
Back to AD 2012-10-13