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.

N515CWiggins Wings LLC · Ponte Vedra Beach, FLBuilt 2019 · S/N 1862N515DCmmk LLC · Talent, ORBuilt 1980 · S/N 340A-1022N515FVSlowmow Inc · Palestine, TXS/N 414-0410N515HDValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11469N515MHWindward Aviation Corp · Santa Clara, CABuilt 2012 · S/N 3841N515MMUtiliplex LLC · Hickory, NCBuilt 2004 · S/N 41046N515RJFroehlich Franz M · Oceanside, CABuilt 1983 · S/N EA-357N515RRHangar 49 Ltd · Wilmington, DEBuilt 1987 · S/N 4608080N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235N515SCLinden Aviation LLC · Naples, FLBuilt 2018 · S/N 4627N515SMApres Logistics LLC · Missouri City, TXBuilt 2022 · S/N 8500N515STQ&A Holdings LLC · Elkridge, MDBuilt 1971 · S/N 414-0169N515TGMilton Steven Pichon · Houston, TXBuilt 1994 · S/N EA-570N515VCAg Av LLC · Jackson, WYBuilt 2016 · S/N 1257N515WTApex Aviation Holding LLC · Kalispell, MTBuilt 2015 · S/N 1039N5160JZemnickas William V · Metamora, MIS/N 340-0550N5163JQuantie Harold · Locust Grove, OKBuilt 1975 · S/N 340-0553N5165JPeak Wings LLC · Missoula, MTBuilt 1975 · S/N 340-0555N5167LLedoux Air LLC · San Antonio, TXBuilt 2025 · S/N 11089N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294N5169JPotter Kent W · Laurel, MTBuilt 1976 · S/N 340A0004N516CPJohnson David A · Belvidere, ILBuilt 2008 · S/N 3321N516CR516 Ontario Capital Holdings LLC · Hartland, WIBuilt 2005 · S/N 1309N516EVAerofly Procurement LLC · Owasso, OKBuilt 2005 · S/N 1445N516KSConcept Cirrus Inc Trustee · Wilmington, DEBuilt 2017 · S/N 1604N516MDShine Air LLC · Windermere, FLBuilt 2025 · S/N 10934N516SRLdw Enterprises LLC · Loretto, TNS/N 2062N517Fresh Air LLC · Camarillo, CABuilt 2016 · S/N 1352N5175FBroomstick Aviation LLC · Fairfield, IABuilt 2004 · S/N 0818N5175JAycock Charles C · Midland, TXS/N 340A0010N5175LAsb Industries LLC · Driggs, IDBuilt 2005 · S/N 1542N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116N5178JSeven Eight Juliet LLC · Edmond, OKS/N 340A0013N517BSFiveoneseven Aviation LLC · Peachtree City, GABuilt 2025 · S/N 10870N517CDPeker Lev M · Sylmar, CABuilt 2004 · S/N 1126N517CPInformation Management Systems Inc · Madison, MSBuilt 2008 · S/N 3323N517DJUrquhart Dan DBA · Fallon, NVBuilt 1997 · S/N E-3075N517LMSoaring Paws Aviation LLC · Dickinson, NDBuilt 2011 · S/N 3715N517PZPapa Zulu LLC · Bend, ORBuilt 2004 · S/N 0931N517SBWhetstone Aviation LLC · Crested Butte, COBuilt 2021 · S/N 2407N517SWStarship Aviation LLC · Northville, MIBuilt 2003 · S/N 0666N5181JForce One Inc · Missoula, MTBuilt 1975 · S/N 340A0016N5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeS/N 340A0017N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114N518AWN All Cirrusness LLC · Lake Charles, LABuilt 2014 · S/N 4129N518BADalton Wholesale Floors Of Gordon County Ga Inc · Adairsville, GABuilt 2015 · S/N 4183N518BPDr James Loging Md LLC · Prosperity, SCBuilt 2007 · S/N 2683N518CDCornerstone Auto Parts LLC · Pratt, KSBuilt 2004 · S/N 1229
Back to AD 2012-10-13