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.

N5084VAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 0831N5089C5089c LLC · Fairhope, ALBuilt 1979 · S/N 21063701N508BMGreen Team Motors LLC · Olathe, KSBuilt 2022 · S/N 9012N508DBCatalano George A · Scottsdale, AZBuilt 2004 · S/N L2K-198N508DFStephens James Anthony · Baton Rouge, LABuilt 1990 · S/N E2541N508DKTravel Express Aviation LLC · West Chicago, ILBuilt 2002 · S/N 0309N508JBJuliet Bravo LLC · Olathe, KSBuilt 2007 · S/N 2474N508JDSterling Aviation Group LLC · Colorado Springs, COBuilt 2008 · S/N 3184N508KMHigh Sierra Holdings LLC · Wellesley, MABuilt 2025 · S/N 10665N508LCThomas Kevin · Gardendale, ALBuilt 2014 · S/N 0835N508RASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2017 · S/N 4458N508SBSms Aviation LLC · Odessa, TXBuilt 2012 · S/N 0361N508TCFisher Travis L · Odessa, TXBuilt 1982 · S/N 21064741N508VBFlight Quest Aviation LLC · Camden, DEBuilt 2023 · S/N 9576N508WHBas Part Sales LLC · Greeley, COBuilt 2018 · S/N 4603N508WKSnow Shore Aviation LLC · Harwich, MABuilt 2025 · S/N 11036N50901United Indian Missions Inc DBA · Tucson, AZBuilt 1973 · S/N U20601951N5091CMartin Steven J · Phoenix, AZBuilt 1982 · S/N T30300132N5096RProvestment International LLC · West Melbourne, FLBuilt 2001 · S/N TH-1996N5098QM&L Engine LLC · Schriever, LABuilt 1971 · S/N 340-0024N509CDTfs Limited LLC · Scarborough, MEBuilt 2004 · S/N 1194N509CETitle Associates LLC · Hurricane, UTBuilt 2004 · S/N 0979N509CMKuppinger Aviation Services LLC · Kissimmee, FLBuilt 2010 · S/N 3509N509CPWalsh Jacob R · Tucson, AZBuilt 2008 · S/N 3320N509MCCicerchi Michael P · Denver, COBuilt 2015 · S/N 57N509PTailwindsbikelyft LLC · Hannibal, MOBuilt 2000 · S/N TH-1947N509RRAlten Flight LLC · Northbrook, ILBuilt 2004 · S/N 0843N509RSHalf Shell Aviation LLC · Highlands Ranch, COBuilt 1978 · S/N 414A0060N509SRWb Holdings LLC · Royal City, WABuilt 2024 · S/N 10366N50BVStrickland H Len Jr · Fairhope, ALBuilt 2022 · S/N 8912N50CBHughes Eugene F Jr · Butte, MTBuilt 1979 · S/N 414A0228N50CTAyers Jeffrey D · Canandaigua, NYBuilt 1978 · S/N 21062937N50DDQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000331N50DNNlw Inc · Indianapolis, INBuilt 2025 · S/N 10758N50ECPremier Wireless LLC · Kalispell, MTBuilt 1998 · S/N 29-0169N50FTN50ft LLC · Boca Raton, FLBuilt 2006 · S/N 2019N50GBOviedo Juan M III · Oak Point, TXBuilt 1975 · S/N 340-0163N50HGBethune David Scott · Stockton, CABuilt 1979 · S/N TJ-217N50MAGoodhue David H · Vancouver, WABuilt 1979 · S/N 414A0434N50RHPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000738N50SHVitatoe Industries Inc · Chillicothe, OHBuilt 1978 · S/N P21000178N50WTBase Aviation LLC · Grand Junction, COBuilt 2015 · S/N 1122N50XLQualitair LLC Trustee · MichelstadtBuilt 2014 · S/N 201169N5105YMcduff Douglas M · Cook, MNBuilt 1980 · S/N 21064074N5106CQuest Aviation Inc · Lake City, FLBuilt 1979 · S/N 21063704N5107CDalrymple Michael J · San Luis Obispo, CABuilt 1979 · S/N 21063705N5107WRugger Investment Group LLC · Sheridan, WYBuilt 1981 · S/N P21000640N5109QRmcb LLC · Kalispell, MTBuilt 1972 · S/N 21059609N510CDMcgraw Jon W · Sitka, AKBuilt 2005 · S/N 1324N510CKCampbellklein Aviation LLC · Whitefish, MTBuilt 2021 · S/N 2350
Back to AD 2012-10-13